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 datetime vars.
Use the column picker in blocks with multiple choice.
The columns suggestion is available in the HAVING block, while setting function parameters.
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 the help of SELECT INTO statement, the database schema suggestion is available.
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 COLLATE 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 a specific join operation.
You can select the pre-set JOIN statement for tables that are joined with a foreign key.
Use the сolumn picker to select required columns to be included into the INSERT statement.
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 statement.
Column suggestion list is available for the INSERTED statement.
There is the possibility to insert execution results into the 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 these variables.
While modifying 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 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 variables.
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 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 servers suggestion is supported.
The suggestion list shows all the 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, and aliases.
Suggestion of DML and DDL triggers is supported.
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 commands available 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 and functions 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 syntax prompts.
The suggestion list shows scalar functions and custom variables for the PRINT statement.
Suggestion for the DECLARE TABLE statement is supported.
The suggestion list shows table variables and columns.
The suggestion list shows temporary tables variables and columns.
The suggestion list shows current users and roles for the current database.
The suggestion list shows the data types for variables.
The suggestion list displays user-defined tables and columns while you are writing a query.
Use a suggestion while creating a nonclustered in-memory columnstore index for a SQL Server table.
The SEQUENCE suggestion is supported.
Columns are suggested when declaring indexes.
Suggestions are available in queries that include a correlated subquery.
Objects declared in a script are suggested.
JSON and JSON AUTO as well as JSON PATH keywords are suggested.
Suggestions are prompted for the following statements:
The suggestion list displays available transactions.
The suggestion list shows filegroups in ALTER DATABASE, CREATE PARTITION, and CREATE TABLE statements.
The suggestion list displays the relevant objects.
The function allows users to change a name of the message type.
With this function, users can easily delete a name of the message type.
After typing a colon operator, the function provides a suggestion list with additional keywords in the SQLCMD mode.
A suggestion list for the CHECK and DEFAULT constraints is available.
OLE DB provider names are now suggested for OPENROWSET and OPENQUERY
The suggestion list of XML methods is supported for XQuery.
In the CREATE TYPE statement, the command suggests context-based prompts for data types and primary keys of server objects.
Suggestion of context-based prompts is available in the CREATE TYPE ...FROM statement.
The SET DATEFORMAT block contains a list of variables and formats when specifying a date.
The prompt list of message types and variables is supported in the SEND ON CONVERSATION clause.
The list of user, file groups, schemas, databases, and procedures is available in the CREATE QUEUE clause.
Depending on the context, the suggestion list will display available schemas, data types, assemblies, and methods in the CREATE AGGREGATE block.
When inserting objects into the FROM block and their correct further renaming, the list of prompts for aggregates is added.
The DBCC CLONEDATABASE database management command is supported.
