SQL Pretty Printer provides the ability to capitalize user defined identifier such as stored procedure name start with sp_ in SQL Server.

name: case_prefix_identitfer

setting path: capitalisation -> Prefix_ident

name: identifier_prefix_list

setting path: capitalisation -> Identifier prefix list

After setting case_prefix_identitfer to uppercase and identifier_prefix_list to sp_,

Unlike some other SQL formatting tools, SQL Pretty Printer able to control the case of variable name in SQL statement, this feature helps you to find out variable in SQL statement quickly.

name: case_variable_name, default is no change.

setting path: capitalisation -> Variable

After setting case_variable_name to upper case,

Unlike some other SQL formatting tools, SQL Pretty Printer able to control the case of alias name in SQL statement, this feature helps you to find out alias in SQL statement quickly.

name: case_alias_name, default is no change.

setting path: capitalisation -> Alias

After setting case_alias_name to upper case,

Unlike some other SQL formatting tools, SQL Pretty Printer able to control the case of column name in SQL statement, this feature helps you to find out columns in SQL statement quickly.

name: case_column_name, default is no change.

setting path: capitalisation -> Column

After setting case_column_name to upper case,

Unlike some other SQL formatting tools, SQL Pretty Printer able to control the case of table name in SQL statement, this feature helps you to find out tables in SQL statement quickly.

name: case_table_name, default is no change.

setting path: capitalisation -> Table

After setting case_table_name to upper case,

This format option controls where to put comma in the list of parameters of SQL Server execute statement. a line break can be placed after comma, or before comma

name: exec_parameters_comma_option, default is put line break after comma

setting path: Execute -> parameter comma option

After set exec_parameters_comma_option to “before comma”, SQL will be formatted like this:

After set exec_parameters_comma_option to “before comma with a space”, SQL will be formatted like this:

This format option controls whether list style of parameters in SQL Server execute statement, it can be stacked or wrapped.

name: exec_parameters_style, default is stacked

setting path: Execute -> parameter style

After set exec_parameters_style to wrapped, SQL will be formatted like this:

This format option controls whether align value of parameter of SQL Server execute statement.

name: exec_parameters_align_value, default is false

setting path: Execute -> align value of parameter

After set exec_parameters_align_value to true, SQL will be formatted like this:

This format option controls whether put a blank line before the first parameter of SQL Server execute statement.

name: exec_first_paramater_in_newline, default is true

setting path: Execute -> first parameter in newline

After set exec_first_paramater_in_newline to false, SQL will be formatted like this:

This format option control whether put a blank line before comparison operator when it follows a subquery.

name: Subquery_Newline_Before_ComparisonOperator, default is false

setting path: subquery -> Linebreak before comparison operator

After set Subquery_Newline_Before_ComparisonOperator to true, SQL will be formatted like this: