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 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.


CREATE INDEX Suggestion

CREATE INDEX Suggestion

Use a suggestion while creating a nonclustered in-memory columnstore index on a SQL Server table.

SELECT Suggestion

SELECT Suggestion

Use the column picker for simple selection of required columns.

FROM Suggestion

FROM Suggestion

The FROM block contains tables, views, table functions, XML vars, table vars, and datetime vars.

GROUP BY Suggestion

GROUP BY Suggestion

Use the column picker in blocks with multiple choice.


JOIN Conditions Prompt

HAVING Suggestion

The columns suggestion is available in the HAVING block, while setting function parameters.

WHERE Conditions Prompt

ORDER BY Suggestion

If you declared columns and aliases in the SELECT statement, the suggestion list will show them in the ORDER BY statement.


Columns Prompt

TOP Suggestion

Suggestion of functions and variables is available in the TOP statement.

Columns Prompt Inside Functions

OFFSET Suggestion

In the OFFSET statement, depending on its context, the suggestion of keywords, variables, or objects is available.


DELETE FROM Prompt

SELECT INTO Suggestion

While creating a table with help of SELECT INTO statement, the database schema suggestion is available.

Prompt on Selected Columns

FOR XML Suggestion

Keywords suggestion for the FOR XML clause is available.


UPDATE Prompt

Window and ranking functions suggestion

Columns and objects suggestion for window and ranking functions is available.

Selection for a Different Schema

Collations Suggestion

For all string data the collates suggestion is available.


Prompt on Cursors

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 specific join operation.

Prompt on Cursors with Parameters

JOIN Suggestions

You can select the pre-set JOIN statement for tables that are joined with a foreign key.


Prompt on RECORD fields

INSERT Suggestions

Use the —Āolumn picker to select required columns to be included into the INSERT statement.

%ROWTYPE Attribute for the RECORD Prompt

INSERT VALUES Suggestion

Variable and scalar functions are suggested in the VALUES block for the INSERT statement.


Prompt on RECORD Type Variables

OUTPUT Suggestion

There is the possibility to display required data using INSERTED, in the OUTPUT statement.

REF-CURSOR Variables Prompt

Suggestion for virtual tables

Columns suggestion list is available for the INSERTED statement.


Prompt on Variables inside SELECT INTO

INTO Suggestion

There is the possibility to insert execution results into available table object.

Assign a Value to a Variable

Suggestion for XML in FROM clause

XML vars suggestion is available in the FROM statement.


Variable Initialization Prompt

Build-in methods suggestion for XML datatypes

Suggestion for built-in methods is available for XML type variables.

Prompt on Function Parameters

XML alias suggestion

Suggestion for built-in methods is available for XML type variables via aliases.


Prompt on Stored Procedures Parameters

XML build-ins suggestion in SELECT

The SELECT statement displays custom variables and built-in methods to work with these variables.

Recursive Calls Prompt

XML build-ins suggestion in SET

While attempting to modify XML data, an appropriate method is suggested.


Prompt on Procedures Declared in Packages

XML columns suggestion

Suggestion of built-in methods for XML columns.

Prompt on Package Functions and Variables

PIVOT Suggestion

Columns and aliases suggestion is available for the PIVOT statement.


SEQUENCE Built-in Functions

UNPIVOT Suggestion

In the UNPIVOT statement the suggestion list shows columns from an external table statement.

Prompt on Built-in methods of Table Type

SET IDENTITY_INSERT suggestion

In the SET statement the suggestion list shows objects, if it is allowed by syntax.


Prompt on Built-in Array Methods

Variables suggestion for SET commands

For the SET statement that expects a value, the suggestion list shows appropriate variables.

Prompt on SELF-type variables

SET command suggestion

Extended suggestion for all the SET options is available.


Prompt on Objects inside FETCH INTO

UPDATE suggestion

Custom tables and views are suggested in the UPDATE statement.

Prompt on User-Defined Types

UPDATE SET suggestion

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.


Prompt on Objects inside FOR IN

Updating value suggestion

For the column, that is being updated you can set a value using either a custom or a system function.

Variables Prompt in the VALUES Block

Linked servers suggestion

Linked server suggestion is supported.


Objects Prompt in the User-Defined Package

Linked server objects suggestion

The suggestion list shows all existing objects for every linked server.

Prompt inside CREATE TABLE

ALTER objects suggestion

The suggestion list shows an object name depending on the ALTER statement type.


Prompt inside CREATE VIEW

DROP objects suggestion

The DROP statement behavior is the same as the ALTER statement.

Prompting Objects in the DROP statement

Breadcrumb suggestion

Breadcrumb object suggestion is supported.


Prompting NEW/OLD Variables Columns

Column datatypes suggestion in CREATE TABLE statement

The suggestion list shows all the available data types while creating a new table.

Prompt on Triggers

Columns suggestion in ALTER TABLE statement

Extended suggestion syntax for the ALTER statement allows to see custom objects and available columns.


Objects Prompt inside the ALTER Statement

Cursors suggestion

The suggestion list shows all the available cursor variables in the cursor statements.

Prompt on Triggers

Fetch suggestion

The suggestion list shows custom variables in the FETCH statement.


Objects Prompt inside the ALTER Statement

DELETE FROM suggestion

The suggestion list shows custom tables and views for the DELETE statement.

Prompt on Triggers

WHERE suggestion

The completion list shows available columns and scalar functions for a selected object in the DELETE statement.


Objects Prompt inside the ALTER Statement

TRUNCATE suggestion

The completion list shows custom tables in the TRUNCATE statement.

Prompt on Triggers

Default schema suggestion

In case you do not specify a schema explicitly, the suggestion list shows objects from a default schema.


Objects Prompt inside the ALTER Statement

Filtering objects by default schema

In case you specify a schema explicitly, the suggestion list shows objects from the specified schema.

Prompt on Triggers

CTE suggestion

Common Table Expressions (CTE) suggestion is supported.


Objects Prompt inside the ALTER Statement

Recursive CTE suggestion

For the recursive CTE statements the suggestion list shows scalar functions, columns, and aliases.

Prompt on Triggers

Triggers suggestion

Triggers suggestion is available.


Objects Prompt inside the ALTER Statement

Virtual tables suggestion

The suggestion list shows virtual tables (DELETED/INSERTED) in the trigger body.

Prompt on Triggers

Columns suggestion for virtual tables

The suggestion list shows columns to which you refer using virtual tables (DELETED/INSERTED).


Objects Prompt inside the ALTER Statement

Synonym suggestion

Synonyms suggestion for custom objects is supported.

Prompt on Triggers

Query hints suggestion

You can specify a hint for the query optimizer.


Objects Prompt inside the ALTER Statement

Table hints suggestion

You can use table hints.

Prompt on Triggers

SQLCMD mode suggestion

The suggestion list shows variables in the SQLCMD mode.


Objects Prompt inside the ALTER Statement

System variables suggestion

The suggestion list shows system variables in the places where a value is expected.

Prompt on Triggers

LABELS suggestion

If the script contains a label, the suggestion list shows one in the GOTO context.


Objects Prompt inside the ALTER Statement

DBCC commands suggestion

DBCC commands suggestion is supported.

Prompt on Triggers

Suggestion for hierarchyid datatypes

The suggestion list shows built-in methods for hierarchical data types.


Objects Prompt inside the ALTER Statement

BULK INSERT suggestion

Extended syntax suggestion for the BULK INSERT statement is supported.

Prompt on Triggers

Stored procedures suggestion

The suggestion list shows stored procedures in the EXEC statement.


Objects Prompt inside the ALTER Statement

MERGE suggestion

The suggestion list shows columns and aliases in the MERGE statement.

Prompt on Triggers

RAISERROR suggestion

For the vast majority of T-SQL statements the suggestion list provides extended syntax prompts.


Objects Prompt inside the ALTER Statement

PRINT suggestion

The suggestion list shows scalar functions and custom variables for the PRINT statement.

Prompt on Triggers

DECLARE TABLE suggestion

Suggestion for DECLARE TABLE statement is supported.


Objects Prompt inside the ALTER Statement

Table variables suggestion

The suggestion list shows table variables and columns.

Prompt on Triggers

Temporary tables suggestion

The suggestion list shows temporary tables variables and it's columns.


Objects Prompt inside the ALTER Statement

Users and roles suggestion

The suggestion list shows current users and roles for the current database.

Prompt on Triggers

Datatypes suggestion

The suggestion list shows the data types for variables.


User Defined Table Type Suggestion

User Defined Table Type Suggestion

The suggestion list displays user-defined tables and columns while you writing a query.



SQL Complete: smart autocomplete for SQL Server developers & DBAs