TechNet
Export (0) Print
Expand All

SqlScriptGeneratorOptions Class

 

Controls the options for Sql Script Generation.

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

System.Object
  Microsoft.SqlServer.TransactSql.ScriptDom.SqlScriptGeneratorOptions

No code example is currently available or this language may not be supported.

NameDescription
System_CAPS_pubmethodSqlScriptGeneratorOptions()

Initializes a new instance of the SqlScriptGeneratorOptions class.

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.

NameDescription
System_CAPS_pubmethodEquals(Object)

(Inherited from Object.)

System_CAPS_protmethodFinalize()

(Inherited from Object.)

System_CAPS_pubmethodGetHashCode()

(Inherited from Object.)

System_CAPS_pubmethodGetType()

(Inherited from Object.)

System_CAPS_protmethodMemberwiseClone()

(Inherited from Object.)

System_CAPS_pubmethodReset()

Resets the options to their default value.

System_CAPS_pubmethodToString()

(Inherited from Object.)

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Return to top
Show:
© 2016 Microsoft