SQL Formatter Options SQL Formatter Options

Defines the setup for SQL Formatter.

Setup for SQL Formatter

Setup for SQL Formatter

'Variable Name' is the name of the variable used to store the SQL statement. 'Line Length' the maximum width of any one line. 'Double Quotes' controls if any double quote characters are converted to single quote characters. If the option 'Use Line Continuation' is selected then the SQL consists of one line broken up with line continuations. 'Declare Variable' controls if a variable is used. If 'Left Align SQL Statements' is selected then the keywords 'WHERE' and 'FROM' are always left aligned in the formatted SQL Statement.

For both table names and reserved words you can select various capitalisation styles. The options are 'None', 'Uppercase', Lowercase' and 'Initial Caps.'. When 'Initial Caps.' is used with table names you select which character to use, for reserved words it's fixed with the first character. '