This topic describes autocompletion features provided by SQL Complete.
From the first characters that you are typing in the SQL editor, SQL Complete determines the most relevant suggestions for the current context and displays them in a list. You can cancel the automatic display of suggestions or edit the delay time used to display them.
If you are typing first several characters of a database object name, and SQL Complete finds only one match, it automatically inserts it to complete the word.
SQL Complete can assign an alias to each table object (table, view, function, synonym, sub-query) available in the FROM list of your SQL statement automatically.
When typing statements within a database, you can get suggested objects of another database if you specify its name in the query text.
The feature allows you to see all identifier occurrences. In a few moments after the pointer was placed over the identifier, all the identifier occurrences in the text will be highlighted.
SQL Complete highlights both the opening and closing code elements to visually define separate code blocks. This feature allows you to determine whether element pairs are properly paired and determine mismatched or misspelled paired code elements. To highlight a pair, click one element of the pair. For example, when you place a caret at the BEGIN or END keyword, SQL Complete automatically highlights both matching keywords. SQL Complete recognizes the following sets of delimiters: IF…ELSE, BEGIN…END, BEGIN TRY…END TRY, CASE..END.
SQL Complete sorts names of database objects by type and displays most relevant suggestions at the top of the list.
SQL Complete automatically filters object names and keywords in the list depending on what you are typing. Filtering is sensitive to the typed characters, symbols, white space and CamelCase. For example, if you type SELECT * FROM PC, compound names which elements start with the P and C characters (CamelCase) will be suggested.
SQL Complete can suggest methods for columns and variables of the varchar(max), nvarchar(max), varbinary(max), and xml types.
For columns and variables of the varchar(max), nvarchar(max), and varbinary(max) data types, the WRITE method can be suggested.
For columns and variables of the xml data type, the query(), value(), exist(), modify(), and nodes() methods can be suggested.
All these methods can be suggested (except WRITE and nodes()) within calculated expressions and after column identifiers of these types with a point.
- The WRITE method can be called in UPDATE and SET statements only.
- The nodes() method can be called only in the FROM list.
SQL Complete provides context-based suggestions and formatting in the following queries:
In all other statements, only context-based suggestions of keywords are supported.
When your code is overlapped by the suggestion box, hold Ctrl to make the suggestion box semi-transparent.
Keywords in the suggestion list may be sorted by relevance. If the Sort keywords by relevance option is not selected, keywords are sorted in alphabetical order.
The feature allows grouping keywords in the suggestion list by the degree of keyword relevance to some specific context. This helps to determine the most appropriate keywords for commit.
The Sort keywords by relevance property is enabled (keywords are sorted by relevance)
The Sort keywords by relevance property is disabled (keywords are sorted in alphabetical order)
* These features are available in the Standard edition of SQL Complete only.
** The Express edition of SQL Complete offers partial support of these features. Full support is available in the Standard edition only.