You can set various options for how SQL Prompt behaves in the SQL Prompt Options dialog box. This page describes the options available on the first page of the SQL Prompt Options, the Behavior page. For other more specific options, see the following:

• Customizing inserted code
• Managing connections and memory
• Changing the location of the settings and snippet folders
• SQL Prompt Labs

To open 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 shown until you select the check box again.

Turning off the object definition box

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

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.

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.

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.

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:

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.

Importing and exporting all options

You can import and export all your SQL Prompt options using the buttons at the bottom of the Options dialog box:

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:

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:

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