dbForge SQL Complete and its embedded T-SQL
prompts give you a chance to implement code routines rationally. T-SQL context prompt
accelerates the writing of SQL code by offering a list of database objects and T-SQL
statements to be inserted, based on the context of what you type in the SQL editor.
Use the column picker for simple selection of required columns.
The FROM block contains tables, views, table functions, XML vars, table vars, and
Use the column picker in blocks with multiple choice.
The columns suggestion is available in the HAVING block, while setting function
If you declared columns and aliases in the SELECT statement, the suggestion list
will show them in the ORDER BY statement.
Suggestion of functions and variables is available in the TOP statement.
In the OFFSET statement, depending on its context, the suggestion of keywords, variables,
or objects is available.
While creating a table with help of SELECT INTO statement, the database schema suggestion
Keywords suggestion for the FOR XML clause is available.
Columns and objects suggestion for window and ranking functions is available.
For all string data the collates suggestion is available.
You can use the automatically created JOIN statement while combining tables. You
can also select table objects from a required schema manually, in case you need
specific join operation.
You can select the pre-set JOIN statement for tables that are joined with a foreign
Use the сolumn picker to select required columns to be included into the INSERT
Variable and scalar functions are suggested in the VALUES block for the INSERT statement.
There is the possibility to display required data using INSERTED, in the OUTPUT
Columns suggestion list is available for the INSERTED statement.
There is the possibility to insert execution results into available table object.
XML vars suggestion is available in the FROM statement.
Suggestion for built-in methods is available for XML type variables.
Suggestion for built-in methods is available for XML type variables via aliases.
The SELECT statement displays custom variables and built-in methods to work with
While attempting to modify XML data, an appropriate method is suggested.
Suggestion of built-in methods for XML columns.
Columns and aliases suggestion is available for the PIVOT statement.
In the UNPIVOT statement the suggestion list shows columns from an external table
In the SET statement the suggestion list shows objects, if it is allowed by syntax.
For the SET statement that expects a value, the suggestion list shows appropriate
Extended suggestion for all the SET options is available.
Custom tables and views are suggested in the UPDATE statement.
The suggestion list shows all the available columns for the selected object. You
can can refer to these columns via the name of the object that is being updated.
For the column, that is being updated you can set a value using either a custom
or a system function.
Linked server suggestion is supported.
The suggestion list shows all existing objects for every linked server.
The suggestion list shows an object name depending on the ALTER statement type.
The DROP statement behavior is the same as the ALTER statement.
Breadcrumb object suggestion is supported.
The suggestion list shows all the available data types while creating a new table.
Extended suggestion syntax for the ALTER statement allows to see custom objects
and available columns.
The suggestion list shows all the available cursor variables in the cursor statements.
The suggestion list shows custom variables in the FETCH statement.
The suggestion list shows custom tables and views for the DELETE statement.
The completion list shows available columns and scalar functions for a selected
object in the DELETE statement.
The completion list shows custom tables in the TRUNCATE statement.
In case you do not specify a schema explicitly, the suggestion list shows objects
from a default schema.
In case you specify a schema explicitly, the suggestion list shows objects from
the specified schema.
Common Table Expressions (CTE) suggestion is supported.
For the recursive CTE statements the suggestion list shows scalar functions, columns,
Triggers suggestion is available.
The suggestion list shows virtual tables (DELETED/INSERTED) in the trigger body.
The suggestion list shows columns to which you refer using virtual tables (DELETED/INSERTED).
Synonyms suggestion for custom objects is supported.
You can specify a hint for the query optimizer.
You can use table hints.
The suggestion list shows variables in the SQLCMD mode.
The suggestion list shows system variables in the places where a value is expected.
If the script contains a label, the suggestion list shows one in the GOTO context.
DBCC commands suggestion is supported.
The suggestion list shows built-in methods for hierarchical data types.
Extended syntax suggestion for the BULK INSERT statement is supported.
The suggestion list shows stored procedures in the EXEC statement.
The suggestion list shows columns and aliases in the MERGE statement.
For the vast majority of T-SQL statements the suggestion list provides extended
The suggestion list shows scalar functions and custom variables for the PRINT statement.
Suggestion for DECLARE TABLE statement is supported.
The suggestion list shows table variables and columns.
The suggestion list shows temporary tables variables and it's columns.
The suggestion list shows current users and roles for the current database.
The suggestion list shows the data types for variables.
Need more than a sole tool?
Try dbForge Fusion for SQL Server
If you are an SQL Server MVP,
send us a link to your Microsoft MVP profile and get a free
licence for any SQL Server product!
Learn more about SQL Azure support in
Thanks to you and your company for making such a great program, many of the people
here can't wait to get rid of SQL Prompt.
Read more Your testimonial
Say a few words about the product and
You might be also interested in:
SQL Server management tools: