Statement expansion
This section describes the following features:
- Wildcard expansion with column list insertion
- Expand the INSERT statement
- Expand the UPDATE statement
- Expand the ALTER statement
- Expand stored routine parameters
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.
Want to Find out More?
Overview
All features
Request a demo
