dbForge SQL Complete and its embedded T-SQL prompts give you a chance to implement code routines rationally. T-SQL context prompt accelerates 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. The feature brings a vast improvement to code quality and saves you the trouble of typing SQL queries manually.
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 by foreign keys and column names.
Use the column 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 a possibility to display required data using INSERTED, in the OUTPUT statement.
Columns suggestion list is available for the INSERTED or DELETED statements.
There is a 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 suggestion list displays context-based objects in the DROP statement.
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 for a user with the default schema assigned, for example, a "Sales" schema, the suggestion list shows objects from a default schema. In case you specify the database and do not specify the schema like the following "SELECT * FROM AdventureWorks2019", the suggestion list shows objects from a default schema as well. If you select any table from the suggested list from the default schema and commit the selection from a completion list, SQL Complete will insert the table name without a schema prefix.
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 logical tables (DELETED/INSERTED).
Synonyms suggestion for custom objects is supported.
You can specify a hint for the query optimizer.
The USE HINT query hint argument provides a method to add behavior to a single query and lets you drive the query optimizer without elevated credentials or without being a member of the sysadmin server role.
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.
SQL Complete tool supports DBCC CHECKIDENT command and prompts table_name arguments for it.
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.
Index selection in WITH clauses can greatly speed up your coding and thus improve your overall performance.
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 the name of the message type.
With this function, users can easily delete the name of the message type.
A suggestion list for the CHECK and DEFAULT constraints is available.
OLE DB provider names are 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.
AT TIME ZONE converts an inputdate to the corresponding datetimeoffset value in the target time zone. The SQL Complete tool suggests time zones when writing SQL queries, helping format your SQL instances and handle all time zone calculations.
Properties for built-in metadata functions (SERVERPROPERTY, FILEPROPERTY, DATABASEPROPERTYEX, etc) are now prompted, allowing you to make full use of the system catalog to find out more about a database.
Temporary tables variables and columns are suggested regardless of the database specified in the USE statement.
SQL Complete can suggest SQL server objects when working with OPENJSON SQL Server table-valued function.
SQL Complete supports the GRANT ALTER ANY statement, cutting time and reducing errors when working with permissions on a database in SQL Server.
SQL Complete supports the CREATE AVAILABILITY GROUP statement helping to quickly create a new availability group, if the instance of SQL Server is enabled for the Always On availability groups feature.
SQL Complete prompts the ALTER EXTERNAL LIBRARY statement when you need to upload the library bits to the database.
SQL Complete suggests the DROP EXTERNAL RESOURCE POOL statement used to Delete a Resource Governor external resource pool needed to define resources for external processes.
SQL Complete prompts sensitivity label and information type attributes as well as marks columns containing personal or confidential information in the suggestion window.
The suggestion list of the algorithm includes RSA_2048, RSA_1024, and RSA_512.
SQL Complete displays the suggestion of context-based keywords and objects in the DBCC SHOW_STATISTICS statement.
SQL Complete suggests context-based keywords in the CREATE COLUMN MASTER KEY statement.
The COLUMN MASTER KEY server object and ALGORITHM are now suggested in the CREATE COLUMN ENCRYPTION KEY statement.
In the CONTAINS predicate, SQL Complete can suggest a list of columns specified in the FROM statement, a list of languages for LANGUAGE, and variables for the DECLARE statement.