Export (0) Print
Expand All

SqlScriptGeneratorOptions Properties

The SqlScriptGeneratorOptions type exposes the following members.

  Name Description
Public property AlignClauseBodies Gets or sets a value that indicates whether the bodies of FROM, WHERE, GROUP BY, clauses are aligned.
Public property AlignColumnDefinitionFields Gets or sets a value that indicates whether column definition fields (column name, data type, constraints) are aligned into alignment columns.
Public property AlignSetClauseItem Gets or sets a value that indicates whether the SET clause items in an UPDATE statement is aligned.
Public property AsKeywordOnOwnLine Gets or sets a value that indicates whether the AS keyword is written on its own line.
Public property IncludeSemicolons Gets or sets a value that indicates whether a semi colon is included after each statement.
Public property IndentationSize Gets or sets the number of spaces to use when indenting text.
Public property IndentSetClause Gets or sets a value that indicates whether the SET clause for an UPDATE statement is indented.
Public property IndentViewBody Gets or sets a value that indicates whether the view statement body is indented.
Public property KeywordCasing Gets or sets the keyword casing option to use during script generation.
Public property MultilineInsertSourcesList Gets or sets a value that indicates whether the INSERT column sources list is spread across multiple lines.
Public property MultilineInsertTargetsList Gets or sets a value that indicates whether the INSERT column targets list is spread across multiple lines.
Public property MultilineSelectElementsList Gets or sets a value that indicates whether select elements are listed as multi-line list.
Public property MultilineSetClauseItems Gets or sets a value that indicates whether the SET clause items are listed on multiple lines.
Public property MultilineViewColumnsList Gets or sets a value that indicates whether the view statement columns are listed as a multi-line list.
Public property MultilineWherePredicatesList Gets or sets a value that indicates whether WHERE predicates (expressions separated by AND, and OR) are written on multiple lines.
Public property NewLineBeforeCloseParenthesisInMultilineList Gets or sets a value that indicates whether a newline is placed before a close parenthesis when writing a multi-line list in parenthesis.
Public property NewLineBeforeFromClause Gets or sets a value that indicates whether a newline exists before the FROM clause in a SELECT statement.
Public property NewLineBeforeGroupByClause Gets or sets a value that indicates whether a newline exists before the GROUP BY clause in a SELECT statement.
Public property NewLineBeforeHavingClause Gets or sets a value that indicates whether a newline exists before the HAVING clause in a SELECT statement.
Public property NewLineBeforeJoinClause Gets or sets a value that indicates whether a newline exists before the JOIN clause in a SELECT statement.
Public property NewLineBeforeOffsetClause Gets or sets a value that indicates whether a newline exists before the OFFSET clause.
Public property NewLineBeforeOpenParenthesisInMultilineList Gets or sets a value that indicates whether a newline is placed before an open parenthesis when writing a multi-line list in parenthesis.
Public property NewLineBeforeOrderByClause Gets or sets a value that indicates whether a newline exists before the ORDER BY clause in a SELECT statement.
Public property NewLineBeforeOutputClause Gets or sets a value that indicates whether a newline exists before the OUTPUT clause.
Public property NewLineBeforeWhereClause Gets or sets a value that indicates whether a newline exists before the WHERE clause in a SELECT statement.
Public property SqlVersion Gets or sets the Sql version to generate script for.
Top
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft