TechNet
Export (0) Print
Expand All

SqlScriptGeneratorOptions Properties

 

Namespace:   Microsoft.SqlServer.TransactSql.ScriptDom
Assembly:  Microsoft.SqlServer.TransactSql.ScriptDom (in Microsoft.SqlServer.TransactSql.ScriptDom.dll)

NameDescription
System_CAPS_pubpropertyAlignClauseBodies

Gets or sets a value that indicates whether the bodies of FROM, WHERE, GROUP BY, clauses are aligned.

System_CAPS_pubpropertyAlignColumnDefinitionFields

Gets or sets a value that indicates whether column definition fields (column name, data type, constraints) are aligned into alignment columns.

System_CAPS_pubpropertyAlignSetClauseItem

Gets or sets a value that indicates whether the SET clause items in an UPDATE statement is aligned.

System_CAPS_pubpropertyAsKeywordOnOwnLine

Gets or sets a value that indicates whether the AS keyword is written on its own line.

System_CAPS_pubpropertyIncludeSemicolons

Gets or sets a value that indicates whether a semi colon is included after each statement.

System_CAPS_pubpropertyIndentationSize

Gets or sets the number of spaces to use when indenting text.

System_CAPS_pubpropertyIndentSetClause

Gets or sets a value that indicates whether the SET clause for an UPDATE statement is indented.

System_CAPS_pubpropertyIndentViewBody

Gets or sets a value that indicates whether the view statement body is indented.

System_CAPS_pubpropertyKeywordCasing

Gets or sets the keyword casing option to use during script generation.

System_CAPS_pubpropertyMultilineInsertSourcesList

Gets or sets a value that indicates whether the INSERT column sources list is spread across multiple lines.

System_CAPS_pubpropertyMultilineInsertTargetsList

Gets or sets a value that indicates whether the INSERT column targets list is spread across multiple lines.

System_CAPS_pubpropertyMultilineSelectElementsList

Gets or sets a value that indicates whether select elements are listed as multi-line list.

System_CAPS_pubpropertyMultilineSetClauseItems

Gets or sets a value that indicates whether the SET clause items are listed on multiple lines.

System_CAPS_pubpropertyMultilineViewColumnsList

Gets or sets a value that indicates whether the view statement columns are listed as a multi-line list.

System_CAPS_pubpropertyMultilineWherePredicatesList

Gets or sets a value that indicates whether WHERE predicates (expressions separated by AND, and OR) are written on multiple lines.

System_CAPS_pubpropertyNewLineBeforeCloseParenthesisInMultilineList

Gets or sets a value that indicates whether a newline is placed before a close parenthesis when writing a multi-line list in parenthesis.

System_CAPS_pubpropertyNewLineBeforeFromClause

Gets or sets a value that indicates whether a newline exists before the FROM clause in a SELECT statement.

System_CAPS_pubpropertyNewLineBeforeGroupByClause

Gets or sets a value that indicates whether a newline exists before the GROUP BY clause in a SELECT statement.

System_CAPS_pubpropertyNewLineBeforeHavingClause

Gets or sets a value that indicates whether a newline exists before the HAVING clause in a SELECT statement.

System_CAPS_pubpropertyNewLineBeforeJoinClause

Gets or sets a value that indicates whether a newline exists before the JOIN clause in a SELECT statement.

System_CAPS_pubpropertyNewLineBeforeOffsetClause

Gets or sets a value that indicates whether a newline exists before the OFFSET clause.

System_CAPS_pubpropertyNewLineBeforeOpenParenthesisInMultilineList

Gets or sets a value that indicates whether a newline is placed before an open parenthesis when writing a multi-line list in parenthesis.

System_CAPS_pubpropertyNewLineBeforeOrderByClause

Gets or sets a value that indicates whether a newline exists before the ORDER BY clause in a SELECT statement.

System_CAPS_pubpropertyNewLineBeforeOutputClause

Gets or sets a value that indicates whether a newline exists before the OUTPUT clause.

System_CAPS_pubpropertyNewLineBeforeWhereClause

Gets or sets a value that indicates whether a newline exists before the WHERE clause in a SELECT statement.

System_CAPS_pubpropertySqlVersion

Gets or sets the Sql version to generate script for.

Return to top
Show:
© 2016 Microsoft