SQL Formatter Option: Line breaking->Create table

SQL Format options index ->Line breaking->Create table

	create table
		left parenthesis in new line
			gFmtOpt.BEStyle_createtable_leftBEOnNewline
				boolean
				default: true
		indent left parenthesis
			gFmtOpt.BEStyle_createtable_leftBEIndentSize
				boolean
				default: 0
		
		right parenthesis in new line
			gFmtOpt.BEStyle_createtable_rightBEOnNewline
				boolean
				default: true
		indent right parenthesis
			gFmtOpt.BEStyle_createtable_rightBEIndentSize
				boolean
				default: 0
		first field in new line
			gFmtOpt.createtable_ListitemInNewLine
				boolean
				default: true
		comma in field list in new line
			gFmtOpt.createtable_ListitemCommaInNewLine
				boolean
				default: false
		space after comma
			gFmtOpt.createtable_ListitemSpaceAfterComma
				integer
				default: 0
		align field by fieldname
			gFmtOpt.createtable_ListitemAlignByName
				boolean
				default: true

SQL before beautify

CREATE TABLE AppUser
(
UserID int NOT NULL identity(1,1) ,
FirstName varchar(100) NOT NULL ,
MiddleInitial char(3) NULL ,
LastName varchar(100) NULL ,
LoginName varchar(100) NULL ,
UserDescription varchar(100) NULL ,
Password varchar(100) NULL ,
CustomerID int NULL ,
CreatedDt datetime constraint def_date_19 default getdate(),
PRIMARY KEY CLUSTERED (UserID ASC)
);

SQL after beautify


CREATE TABLE appuser

(

    userid          INT NOT NULL IDENTITY ( 1, 1 ),

    firstname       VARCHAR ( 100 ) NOT NULL,

    middleinitial   CHAR ( 3 ) NULL,

    lastname        VARCHAR ( 100 ) NULL,

    loginname       VARCHAR ( 100 ) NULL,

    userdescription VARCHAR ( 100 ) NULL,

    password        VARCHAR ( 100 ) NULL,

    customerid      INT NULL,

    createddt       DATETIME CONSTRAINT def_date_19 DEFAULT Getdate ( ),

    PRIMARY KEY CLUSTERED ( userid ASC )

);