Statement expansion

Last modified: March 28, 2025

SQL Complete provides several statement expansion features that help streamline your SQL writing process, making it more efficient and less error-prone.

Wildcard expansion with column list insertion

This feature allows the user to replace the asterisk symbol (*) with the list of columns of the required table or view it with the help of the Tab key.

Insert a columns list using Tab

It is possible to insert a list of columns available for the objects (tables, views, etc.) in the SELECT FROM statement instead of the * symbol by pressing Tab. If such a list can be inserted, a hint is displayed when the pointer is placed after the * symbol.

Expand the INSERT statement

This feature allows the user to type available table names, views, procedures, functions, or triggers in the ALTER, INSERT, EXEC, and UPDATE statements and then expand the statement to the full template by pressing Tab.

Apart from the template, the type of column data will be generated in the comments along with the NOT NULL and ROWGUID properties. For DateTime, a template for inserting time will be created. Additionally, if a default value for a table has been created, the DEFAULT clause is generated.

Expand the UPDATE statement

In the UPDATE statements, a full list of columns from a specified table is inserted into the code that is being typed.

Expand the ALTER statement

dbForge SQL Complete will offer to expand the ALTER statement for triggers, views, procedures, and functions.

Expand stored routine parameters

This feature facilitates debugging by replacing a call to a stored procedure with the stored procedure body - it takes the content of a stored procedure and substitutes the call in the query for it. To apply this feature to the required code, click the Convert EXEC to Script option on the shortcut menu.