T-SQL Context Prompt - Code More Efficiently!
dbForge SQL Complete and its embedded T-SQL
prompts give you a chance to implement code routines rationally. T-SQL context prompt
accelerates the SQL code writing 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
GROUP BY suggestion
Use the column picker in blocks with multiple choice.
The columns suggestion is available in the HAVING block, while setting function
ORDER BY suggestion
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.
SELECT INTO suggestion
While creating a table with the help of SELECT INTO statement, the database schema suggestion
FOR XML suggestion
Keywords suggestion for the FOR XML clause is available.
Window and ranking functions suggestion
Columns and objects suggestion for window and ranking functions is available.
For all string data the COLLATE suggestion is available.
Automatic generation of the JOIN clause
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
a 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
INSERT VALUES suggestion
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
Suggestion for virtual tables
Column suggestion list is available for the INSERTED statement.
There is the possibility to insert execution results into the available table object.
Suggestion for XML in FROM clause
XML vars suggestion is available in the FROM statement.
Built-in method suggestion for XML datatypes
Suggestion for built-in methods is available for XML-type variables.
XML alias suggestion
Suggestion for built-in methods is available for XML-type variables via aliases.
XML built-ins suggestion in SELECT
The SELECT statement displays custom variables and built-in methods to work with
XML built-ins suggestion in SET
While modifying XML data, an appropriate method is suggested.
XML column suggestion
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
SET IDENTITY_INSERT suggestion
In the SET statement the suggestion list shows objects, if it is allowed by syntax.
Variables suggestion for SET commands
For the SET statement that expects a value, the suggestion list shows appropriate
SET command suggestion
Extended suggestion for all the SET options is available.
Custom tables and views are suggested in the UPDATE statement.
UPDATE SET suggestion
The suggestion list shows all the available columns for the selected object. You
can refer to these columns via the name of the object that is being updated.
Updating value suggestion
For the column, that is being updated you can set a value using either a custom
or a system function.
Linked servers suggestion
Linked servers suggestion is supported.
Linked server objects suggestion
The suggestion list shows all the existing objects for every linked server.
ALTER objects suggestion
The suggestion list shows an object name depending on the ALTER statement type.
DROP objects suggestion
The DROP statement behavior is the same as the ALTER statement.
Breadcrumb object suggestion is supported.
Column datatype suggestion in CREATE TABLE statement
The suggestion list shows all the available data types while creating a new table.
Columns suggestion in ALTER TABLE statement
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.
DELETE FROM suggestion
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.
Default schema suggestion
In case you do not specify a schema explicitly, the suggestion list shows objects
from a default schema.
Filtering objects by specified schema
In case you specify a schema explicitly, the suggestion list shows objects from
the specified schema.
Common Table Expressions (CTE) suggestion is supported.
Recursive CTE suggestion
For the recursive CTE statements the suggestion list shows scalar functions, columns,
Triggers suggestion is available.
Virtual table suggestion
The suggestion list shows virtual tables (DELETED/INSERTED) in the trigger body.
Column suggestion for virtual tables
The suggestion list shows columns to which you refer using virtual tables (DELETED/INSERTED).
Synonyms suggestion for custom objects is supported.
Query hints suggestion
You can specify a hint for the query optimizer.
Table hints suggestion
You can use table hints.
SQLCMD mode suggestion
The suggestion list shows variables in the SQLCMD mode.
System variables suggestion
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 command suggestion
DBCC commands suggestion is supported.
Suggestion for hierarchyid datatypes
The suggestion list shows built-in methods for hierarchical data types.
BULK INSERT suggestion
Extended syntax suggestion for the BULK INSERT statement is supported.
Stored procedures suggestion
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.
DECLARE TABLE suggestion
Suggestion for the DECLARE TABLE statement is supported.
Table variable suggestion
The suggestion list shows table variables and columns.
Temporary table suggestion
The suggestion list shows temporary tables variables and columns.
User and role suggestion
The suggestion list shows current users and roles for the current database.
The suggestion list shows the data types for variables.
User-defined table-type suggestion
The suggestion list displays user-defined tables and columns while you are writing a
CREATE INDEX suggestion
Use a suggestion while creating a nonclustered in-memory columnstore index for a
SQL Server table.