General SQL Parser and SQL Pretty Printer Formatter options

Index

Put parenthesis in insert statement into a separate line.

gFmtOpt.Insert_Parenthesis_in_separate_line Type: Boolean Default: false

Example format options:

NameValue
gFmtOpt.Insert_Parenthesis_in_separate_linefalse

Formatted SQL:

INSERT INTO t
            (column1,
             column2)
VALUES      ( @Value1,
              @Value2 ) 

Example format options:

NameValue
gFmtOpt.Insert_Parenthesis_in_separate_linetrue

Formatted SQL:

INSERT INTO t
(
  column1,
  column2
)
VALUES
(
  @Value1,
  @Value2
)