Customization options

To customize the default behavior and make it best suit the users’ needs, go to the SQL Complete menu and select Options.

Options window

The Options window contains the following options and option groups:

Option Group            Option Name            Description
General Check for updates at startup once a week Sets up a weekly check for product updates. The option is selected by default.
General Enable document restoring Enables the restoring of the last closed document sessions. The option is selected by default.
General Enable code completion Enables the code completion features. The sub-options include:

Auto List Members: Suggests object names for use at a certain position of the code.

Auto Parameter Info: Displays a tooltip with information on function parameters when calling a function in a query.

Highlight Occurrences: Highlights all occurrences of the identifier in the code when positioning the cursor on the identifier. The options are selected by default.
General Automatically trigger after 200 ms Triggers code completion after a specified number of milliseconds (200 is set as default).
General Allow sending anonymous usage statistics Allows sending anonymous usage stats that help us improve the product. The option is selected by default.
Advanced Qualify column name with table alias Automatically qualifies a column name in the SELECT statement with table alias. The option is selected by default.
Advanced Qualify column name (no table alias) Automatically qualifies a column name in the SELECT statement with no table alias. The options include:

With table name: Qualifies a column name with a table name separated by a dot.

With schema and table name: Qualifies a column name with a schema and table name separated by a dot.

With database, schema, and table name: Qualifies a column name with the database, schema, and table name separated by a dot.
Advanced Include default schema in object names Includes a default schema in object names.
Advanced Reverse order in ‘JOIN’ condition Displays items in the list for the ON condition in the JOIN clause in the reversed order.
Advanced Add parentheses when inserting functions Adds parentheses when inserting functions. The option is selected by default.
Advanced Decrypt encrypted objects when opening Decrypts encrypted DDL objects when using the Script Object as CREATE/ALTER command. The option is selected by default.
Advanced Enclose identifiers within square brackets Automatically adds square brackets to identifies where needed when developing the code. The options include:
Always
If identifier concurs with keyword
If bracketing is required
One option can be selected at a time.
List Members List Members: Sort keywords by relevance Automatically displays the most relevant context-based keywords. The option is selected by default.
By default, keywords are sorted in alphabetical order.
List Members List Members: Cyclic movement through the suggestion list If users select items in the suggestion list with a keyboard, the selection jumps to the first item when reaching the last item in the list.
List Members Filtering Rule Filters the object names and keywords in the list by matching words (By Matching) and by camel-case words in the name (Camel Case). Both options are selected by default.
List Members Commit Selection Inserts the item from the suggestion list in the following ways:
Press Tab (selected by default)

Press Whitespace

Use the characters specified in the Following characters option (a set of characters can be modified)

Select Add a new line on pressing Enter at the end of the fully typed word if a user wants to add a new empty line when pressing Enter

Enable Select items in the list even if user input is expected. Note: When enabled, any match the user inputs with the keywords in the Completion list highlights the keyword in the list regardless of context. When disabled, any match the user inputs with the keywords in the completion list frames the relevant context-based keyword from the list.

Select Commit snippets immediately to insert a code snippet instantly after pressing Tab without waiting for the hint to appear.
Alias Alias Automatically generates aliases for tables, views, table-valued functions, and synonyms in the following ways:
Generate Alias on commit (selected by default)
Generate aliases in UPPER case
Automatically generate AS clause
There is a table where users can add a custom alias.
Notifications Notifications Allows users to set up query execution notifications:
Notify if query execution exceeds 10 sec (the default value which can be modified)

Notify if execution contains open transactions
Users can also set up notification duration. (7 seconds are set as default)
Suggestions Suggestions Allows users to customize the suggestion list:
Do not load suggestions for the following databases to exclude the databases from the suggestion list

Keep connection open to ping the SQL Server to validate the status of the open connection. If the connection is closed, it will notify and prompt a user to reconnect.
Both options are selected by default.
Suggestions Refresh Allows users to customize the refresh settings:
Automatically refresh local cache every 3 minute(s). The time period can be modified.

Detect changes on a server before refreshing local cache
Both options are selected by default.
Data Export Data Export to CSV Allows users to set up data export options:
Use Unicode: Creates a .csv file with a Unicode character encoding. The option is selected by default.

Show a table header: Indicates whether to write column headers. The option is selected by default.

Quote string: Encloses a string in quotes. The recommended options are single quote mark or double quote mark. The double quote mark is set as default.

Force quote: Indicates whether quoting should be optional (if cleared) or added at all times (if selected).

Field separator: Defines a field separator by using one of the available options: comma, semicolon, Tab, or Space. The comma is set as default.
Query Result Grid Summary Panel Visibility Allows users to customize the visibility of the Aggregates panel by setting one of the following options:
Never: Hides the Aggregates panel on the results grid.

Always: Displays the Aggregates panel on the results grid. The option is set as default.

When multiple cells are selected: Displays the Aggregates panel if several cells are selected.

The user can also limit the number of characters after delimiter (2 is set as default).
Execution History Execution History Allows users to customize the execution history:
Enable history: Enable query execution history.

Store executed queries within 60 days: Set the number of days to store executed queries. 60 days are set by default.

Max script size to store 1024 KB: Specify the maximum script size to store. 1024 KB is set as default.

Show history at startup from last week: Displays the execution history at startup beginning from the specified time period. Last week is set as default.

Folder to store: Specify the path to the folder where execution history is stored

If a user wants to remove execution history, use the Clear Execution History option.
SSMS Caption SSMS Main Window Title Allows users to define custom naming pattern for the SSMS main window title.
The Change default SQL Server Management Studio title option is selected by default. Users can define naming of the templates.

The parameters of the template include:
[]: Group of literals. If literals are not available, the group will not displayed.
$Database$: Current database name for the document.
$File$: File name.
$Project$: Current project name for the document.
$Server$: Current server name for the document.
$User$: Current user name for the document.
$IsModified$: Asterisk signals notifying whether the document is modified or not.
SSMS Caption SSMS SQL Document Tab Allows users to define custom naming pattern for the SQL document tab.
The Change default SQL Server Management Studio SQL document tab name option is selected by default. Users can define naming of the templates.

The parameters of the template include:
[]: Group of literals. If literals are not available, the group will not displayed.
$Database$: Current database name for the document.
$File$: File name.
$Server$: Current server name for the document.
$User$: Current user name for the document.

Users can select the Adjust tab width by caption option.
CRUD General Allows users to add the CRUD procedures, which in SQL they refer to Insert, Select, Update, and Delete, and set the order of the columns (either By Ordinal Number or Alphabetically).
CRUD Select Allows users to customize the name and code template of the Select procedure and select Return all data if input parameters are null. For more information about the template parameters and options, see Generate CRUD procedures for a table.
CRUD Insert Allows users to customize the name and code template of the Insert procedure, and select Return inserted row. For more information about the template parameters and options, see Generate CRUD procedures for a table.
CRUD Update Allows users to customize the name and code template of the Update procedure and select Return updated row. For more information about the template parameters and options, see Generate CRUD procedures for a table.
CRUD Delete Allows users to customize the name and code template of the Delete procedure. For more information about the template parameters and options, see Generate CRUD procedures for a table.
Tabs Color Environment Categories Allows users to modify the environment category by specifying a server, a database, and environment in a table. In addition, users can create and/or remove color matches.
Tabs Color Tabs Colors Allows users to assign tab colors to the environment, add or remove the environment.
Execution Warnings Execution Warnings Allows users to customize execution warnings settings:
Max script size to analyze: Set the maximum size of the script to be analyzed. The default value is set to 5000 KB.
Enable or disable execution warnings for the DELETE, DROP, TRUNCATE, and UPDATE commands of the specific environment.
Debugging General Settings
Allows users to specify the timeout for debugging. The default value is set to 30 seconds.

Edit and Continue
Allows users to manage changes during a debugging session by using the following options:
Warn me if I make changes
Always restart debugging after I make changes
Always ignore changes and continue debugging
Formatting General: Formatting Allows users to configure formatting options that include:

Automatically format on paste: Automatically format expressions inserted into the SQL document from the clipboard

Automatically format completed statement on delimiter: Automatically format SQL statements after a semicolon is inserted at the end of the statement

Automatically format words while typing: Automatically format SQL satements when typing code phrases. The option is set as default.

Right Margin: Specify the right margin. The default value is set to 80.
Formatting General: Notifications Allows users to manage syntax error behavior in notifications using the following options:
Put syntax errors to Output window
Show syntax error notification window
Both options are selected by default.
Formatting General: Dictionary Allows users to set a path to the dictionary.txt file and specify prefixes. The default prefixes are tbl, fn, and prc.
Formatting Profiles Allows users to customize a predefined set of formatting profiles (grouped as Devart Profiles) or create custom formatting profiles by using the following options:
Create New: Create a new formatting profile and specify its name, Devart profile from which the settings will be copied, and a path to store a profile, and make the profile active.

Add Existing: Import a file with the formating profile.

Open Selected: Open the active formatting profile.

Set as Active: Make the selected formatting profile active. Once done, it will become bold.

If there is a need to reset all options, it is recommended to use import/export settings.

To overwrite the changes applied and set them to the default settings, select Reset Page Defaults.