Setting SQL Editor Preferences

Show line numbers

Display line numbers in the left margin of the editing window. (Default)

Enable syntax validation

Automatically update SQL statement structure in outline view and perform syntax validation while editing. (Default)

Disabling validation also disables portability checking and the outline view.

Portability check target

Database type used as the standard target for portability checks. Syntax validation must be enabled to select a portability target.

In the SQL Editor, each line that is not portable to the target is annotated with the check icon .

Maximum number of lines

Disable syntax validation when content in SQL Editor exceeds this number of lines. Use this option to adjust SQL Editor performance. Default is 1000.

Prompt to disable syntax validation when content exceeds maximum number of lines

Select to prompt before disabling validation. (Default)

Close single quotes

To automatically close single quotes ('), select the check box. (Default)

Close double quotes

To automatically close double quotes ("), select the check box. (Default)

Close braces

To automatically close curly braces { } , select the check box. (Default)

Close comments

To automatically close single quotes (/* */), select the check box. (Default)

Begin-End

To automatically add the END statement (for Transact-SQL), select the check box. (Default)