This topic describes autocompletion features provided by dbForge Studio.
From the first characters that you are typing in the SQL Editor, dbForge Studio 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 dbForge Studio finds only one match, it automatically inserts it to complete the word.
dbForge Studio 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.
dbForge Studio highlights keywords, built-in functions and other objects in the suggestion list basing on corresponding settings of SSMS.
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.
dbForge Studio 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, dbForge Studio automatically highlights both matching keywords. dbForge Studio recognizes the following sets of delimiters: IF…ELSE, BEGIN…END, BEGIN TRY…END TRY, etc.
dbForge Studio sorts names of database objects by type and displays most relevant suggestions at the top of the list.
dbForge Studio 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.
dbForge Studio 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.
dbForge Studio 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 dbForge Studio only.
** The Express edition of dbForge Studio offers partial support of these features. Full support is available in the Standard edition only.