General SQL Parser and SQL Pretty Printer Formatter options

Index

Available format options for create table:

gFmtOpt.BEStyle_createtable_leftBEOnNewline	Type: boolean	Default: false
gFmtOpt.BEStyle_createtable_rightBEOnNewline	Type: boolean	Default: false
gFmtOpt.Createtable_ListitemInNewLine	Type: boolean	Default: false
gFmtOpt.Createtable_Fieldlist_Align_option	Type: TAlignOption	Default: aloLeft
gFmtOpt.DefaultAligntype	Type: TAlignStyle	Default: asStacked
gFmtOpt.DefaultCommaOption	Type: TLinefeedsCommaOption	Default: lfAfterComma

---

Example format options:

Name	Value
BEStyle_createtable_leftBEOnNewline	false
BEStyle_createtable_rightBEOnNewline	false
Createtable_ListitemInNewLine	false
Createtable_Fieldlist_Style_option	aloLeft

Formatted SQL:

CREATE TABLE dept(deptno NUMBER(2),
                  dname  VARCHAR2(14),
                  loc    VARCHAR2(13)) 



---

Example format options:

Name	Value
BEStyle_createtable_leftBEOnNewline	true
BEStyle_createtable_rightBEOnNewline	true
Createtable_ListitemInNewLine	true
Createtable_Fieldlist_Style_option	aloLeft

Formatted SQL:

CREATE TABLE dept
  (
     deptno NUMBER(2),
     dname  VARCHAR2(14),
     loc    VARCHAR2(13)
  ) 



---

Example format options:

Name	Value
BEStyle_createtable_leftBEOnNewline	true
BEStyle_createtable_rightBEOnNewline	true
Createtable_ListitemInNewLine	true
Createtable_Fieldlist_Style_option	aloRight

Formatted SQL:

CREATE TABLE dept
  (
     deptno NUMBER(2),
      dname VARCHAR2(14),
        loc VARCHAR2(13)
  ) 



---

Example format options:

Name	Value
gFmtOpt.DefaultAligntype	asStacked
gFmtOpt.DefaultCommaOption	lfbeforeCommaWithSpace

Formatted SQL:

CREATE TABLE dept(
  deptno  NUMBER(2)
  , dname VARCHAR2(14)
  , loc   VARCHAR2(13)) 



---

Example format options:

Name	Value
gFmtOpt.DefaultAligntype	asWrapped

Formatted SQL:

CREATE TABLE dept(
  deptno NUMBER(2),dname VARCHAR2(14),loc VARCHAR2(13))