SQL Editor Preferences

You can define the behavior of the SQL Editor.

Table 1. General tab
Field Description
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 a check. content assist checkmark con.

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. The default is 1000.
Prompt to disable syntax validation when content exceeds maximum number of lines Select to prompt before disabling validation. (Default)
Table 2. Typing tab
Field Description
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)
Related concepts
SQL Editor
SQL Files
Content Assist
Database Development Perspective
Related tasks
Editing a SQL File
Setting SQL Editor Preferences