Page History

...

1. Select Preferences > SQL Editor.
   
   Image Modified
   
   
2. Change the settings as appropriate in each section and then click Apply. the following options are available:
   • Enable the SQL parser. For performance reasons, you may want to enable the SQL parser only if a SQL file is smaller than the size you specify here.
   • Severity level for semantic validation problems. Choose a security level from this list. This option determines how semantic code errors are flagged in the editor and the Problems view.

   • The link to specify hyperlinks takes you to the Text Editors preference page.

     Info
     Clearing Enable SQL Parser disables many of the "smart" SQL editor features, including code formatting, auto completion, semantic validation, and hyperlinks. For better performance, you may disable the parser for files above a specified size.

...

1. Select Preferences > SQL Editor.
   
   Image Modified
   
   
2. In the Preferences dialog, expand SQL Editor, and then click Code Assist.

...

1. Select Preferences > SQL Editor.
   
   Image Modified 
   
   
2. In the Preferences dialog, expand SQL Editor, and then click Code Formatter.

...

1. Select Preferences > SQL Editor.
2. In the Preferences dialog, expand SQL Editor, and then click Code Formatter.
3. On the Code Formatter pane, click Show or New and a dialog similar to the following appears. 
   
   Image Modified
   
   
4. Make your changes, and then click Apply to preview your changes.
5. Click OK to create the new profile or to exit the Show Profile dialog. 
6. Use the preview pane to preview the changes you make to your code formatting preferences. Changes are not implemented until you click Apply or OK.

...

1. Select Preferences > SQL Editor.
2. In the Preferences dialog, expand SQL Editor, then and click Code Quality.
   
   Image Modified
   
   
3. Change the severity levels by clicking the list next to the category, and then choosing the level. 
4. Click Apply to save your changes.

...

1. Select Preferences > SQL Editor.
2. In the Preferences dialog, expand SQL Editor, and then click Results Viewer.
   
   Image Modified
   
   
3. Make your preference changes, and then save your changes by clicking Apply. The following options are available:

...

1. Select Preferences > SQL Editor.
2. In the Preferences dialog, expand SQL Editor, and then click SQL Templates. The SQL Templates panel displays a list of all SQL code templates currently available. Additionally, when you select a template from the list, the Preview section displays the code block as it will appear when the template is selected in SQL Editor.
   
   Image Modified
   
   
3. Click the check box beside each template to specify whether it is included in the code assist check within SQL Editor. Use the buttons on the right-hand side of the panel to create, edit, or delete SQL templates, as needed.
   When you create or edit a template, the Edit SQL Template dialog appears. 
   
   Image Modified
   
   
4. Enter a Name, Description, and Pattern in the fields provided, and then click OK. If the template name doesn't match an existing SQL code template, your new template is added to the list, and will automatically be considered when the code assist function is executed in SQL Editor. 
5. Select the Use Code Formatter check box to apply code formatting preferences to the specified template. For more information about setting code formatter preferences, see Specify Code Formatter Preferences.

...

1. Select Preferences > SQL Editor.
2. In the Preferences dialog, expand SQL Editor, and then click Syntax Coloring.
   
   Image Modified
   
   
3. Use the tree view provided in the Element window to select the comment type or code element you want to modify. Select the options to the right-hand side of the window to modify it. The Preview window shows a piece of sample code that updates according to the changes you made.

...