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.

4.JPG

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

OK_btn.jpg

Applies any changes made and closes the dialog.

 

 

Cancel.jpg

Closes the dialog without saving any applied changes.

 

 

Apply.jpg

Applies any changes made.

 

 

Reset.jpg

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

 

 

Defaults.jpg

Restores the default values.

 

 

Export.jpg

Exports defined settings to XML file.

 

 

Import.jpg

Imports settings from previously saved XML.

 

 

Help.jpg

Opens the online help.