Setting main behavior options - SQL Prompt

You can set various options for how SQL Prompt behaves on the Main > Behavior page of the SQL Prompt Options dialog box.

To display the SQL Prompt Options dialog box, on the SQL Prompt menu, select Options.

Turning off SQL Prompt code suggestions

Clear the Enable code suggestions check box to stop SQL Prompt offering code suggestions. The suggestions box will not be displayed until you select the check box again.

Turning off the object definition box

When you select a suggestion, the object definition box is displayed, containing information about the selected object. By default, for tables and views, a summary is displayed, listing the column names and data types:

ObjectDefinitionsBox

To view the object creation script instead, click the Script tab.

If you don't want the object definition box to be automatically displayed, clear Display object definitions.

Note: You can view the object definition for a specific object in your query by clicking its tooltip.

Viewing tooltips

Object tooltips display the fully qualified object name for an object when you move the mouse pointer over the object name in your SQL script.

TooltipTable

For tables, views, and stored procedures, you can click this tooltip to view the object definition.

Tooltips can also be displayed for parameters, including parameters for built-in functions.

Functionparameterhint

If you don't want tooltips to be displayed, clear Objects or Parameters under Show tooltips for in the Tooltips section.

Changing the insertion keys

Insertion keys are the keys that insert the currently selected suggestion into your code:

OptionsDialogInsertionKeys

Insertion keys are also used to insert snippet code when you type a snippet into your query. The default insertion keys are ENTER and TAB.

Restoring options to their default setting

You can reset the options in SQL Prompt in two ways:

for a specific page in the Options dialog box
for all options

To restore the options on a single page

Click Restore Defaults in the top right corner:

restorepagedefaults

This will restore only the options on this page to the SQL Prompt defaults.

Options on all other pages are not affected.

To restore all SQL Prompt options

Click Restore All Defaults in the bottom left corner:

restorealldefaults

Options on all pages are reset to the SQL Prompt defaults.

Note: Restore All Defaults also resets all formatting options. If you want to save your formatting options, you should save them as a style. This allows you to reapply them, even if you have restored all defaults. See Using styles to format your code.

Was this article helpful?

Search support