Formatting Options

Click Tools | Formatting Options to open the dialog box displayed below.

The Formatting Options  dialog box allows you to customize available formatting options, to preview the code before/after its formatting, to import the previously saved option sets and to export (save) pre-defined ones.

The dialog consists of the six tabs that match the respective option groups.

Spaces – contains settings which define space formatting for commas, parenthesis and operators

Indentation – defines parameters of indentation for lines, parenthesis in expressions and schemas

Wrapping – includes options for lines and sub-queries wrapping

Placement – contains common placement options for code that is to be formatted

Cases – define letters' cases for SQL keywords and data types

Others – contains options which define using of BEGIN-END statements

Buttons

Button

Description

Applies any changes made and closes the dialog.

 

 

Closes the dialog without saving any applied changes.

 

 

Applies any changes made.

 

 

Restores all options settings to the state that has been last applied.

 

 

Restores the default values.

 

 

Exports defined settings to XML file.

 

 

Imports settings from previously saved XML.

 

 

Opens the online help.