SqlScriptGeneratorOptions

public class SqlScriptGeneratorOptions

Controls the options for Sql Script Generation

public bool AlignClauseBodies { get; set; }

Gets or sets a boolean indicating if the bodies of FROM, WHERE, GROUP BY, etc. clauses should be aligned

public bool AlignColumnDefinitionFields { get; set; }

Gets or sets a boolean indicating if column definition fields (column name, data type, constraints) should be aligned into alignment columns.

public bool AlignSetClauseItem { get; set; }

Gets or sets a boolean indicating if SET clause items in an UPDATE statement should be aligned

public bool AllowExternalLanguagePaths { get; set; }

Gets or sets a boolean indicating if file paths can be used for external language content

public bool AllowExternalLibraryPaths { get; set; }

Gets or sets a boolean indicating if file paths can be used for external library content

public bool AsKeywordOnOwnLine { get; set; }

Gets or sets a boolean indicating if the AS keyword should be written on its own line

public bool IncludeSemicolons { get; set; }

Gets or sets a boolean indicating if a semi colon should be included after each statement

public int IndentationSize { get; set; }

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

public bool IndentSetClause { get; set; }

Gets or sets a boolean indicating if the SET clause for an UPDATE statement should be indented

public bool IndentViewBody { get; set; }

Gets or sets a boolean indicating if the view statement body should be indented.

public KeywordCasing KeywordCasing { get; set; }

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

public bool MultilineInsertSourcesList { get; set; }

Gets or sets a boolean indicating if the INSERT column sources list should be spread across multiple lines

public bool MultilineInsertTargetsList { get; set; }

Gets or sets a boolean indicating if the INSERT column targets list should be spread across multiple lines

public bool MultilineSelectElementsList { get; set; }

Gets or sets a boolean indicating if select elements should be listed as a multi-line list

public bool MultilineSetClauseItems { get; set; }

Gets or sets a boolean indicating if SET clause items should be listed on multiple lines

public bool MultilineViewColumnsList { get; set; }

Gets or sets a boolean indicating if view statement columns should be listed as a multi-line list

public bool MultilineWherePredicatesList { get; set; }

Gets or sets a boolean indicating if WHERE predicates (expressions separated by AND, and OR) should be written on multiple lines

public bool NewLineBeforeCloseParenthesisInMultilineList { get; set; }

Gets or sets a boolean indicating if a newline should be placed before an close parenthesis when writing a multi-line list in parenthesis

public bool NewLineBeforeFromClause { get; set; }

Gets or sets a boolean indicating if there should be a newline before the FROM clause in a SELECT statement

public bool NewLineBeforeGroupByClause { get; set; }

Gets or sets a boolean indicating if there should be a newline before the GROUP BY clause in a SELECT statement

public bool NewLineBeforeHavingClause { get; set; }

Gets or sets a boolean indicating if there should be a newline before the HAVING clause in a SELECT statement

public bool NewLineBeforeJoinClause { get; set; }

Gets or sets a boolean indicating if there should be a newline before the JOIN clause in a SELECT statement

public bool NewLineBeforeOffsetClause { get; set; }

Gets or sets a boolean indicating if there should be a newline before the OFFSET clause

public bool NewLineBeforeOpenParenthesisInMultilineList { get; set; }

Gets or sets a boolean indicating if a newline should be placed before an open parenthesis when writing a multi-line list in parenthesis

public bool NewLineBeforeOrderByClause { get; set; }

Gets or sets a boolean indicating if there should be a newline before the ORDER BY clause in a SELECT statement

public bool NewLineBeforeOutputClause { get; set; }

Gets or sets a boolean indicating if there should be a newline before the OUTPUT clause

public bool NewLineBeforeWhereClause { get; set; }

Gets or sets a boolean indicating if there should be a newline before the WHERE clause in a SELECT statement

public bool NewLineBeforeWindowClause { get; set; }

Gets or sets a boolean indicating if there should be a newline before the WINDOW clause in a SELECT statement

public SqlEngineType SqlEngineType { get; set; }

Gets or sets the Sql engine type (All|Engine|Azure) to generate script for

public SqlVersion SqlVersion { get; set; }

Gets or sets the Sql version to generate script for

public SqlScriptGeneratorOptions()

public void Reset()

Resets the options to their default value.

Microsoft.SqlServer.TransactSql.ScriptDom by Microsoft

.NET API 5,160,480 bytes

SqlScriptGeneratorOptions