SqlScriptGeneratorOptions SqlScriptGeneratorOptions SqlScriptGeneratorOptions Class

Definition

Controls the options for Sql Script Generation

public class SqlScriptGeneratorOptions
type SqlScriptGeneratorOptions = class
Public Class SqlScriptGeneratorOptions
Inheritance
SqlScriptGeneratorOptionsSqlScriptGeneratorOptionsSqlScriptGeneratorOptions

Constructors

SqlScriptGeneratorOptions() SqlScriptGeneratorOptions() SqlScriptGeneratorOptions()

Properties

AlignClauseBodies AlignClauseBodies AlignClauseBodies

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

AlignColumnDefinitionFields AlignColumnDefinitionFields AlignColumnDefinitionFields

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

AlignSetClauseItem AlignSetClauseItem AlignSetClauseItem

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

AsKeywordOnOwnLine AsKeywordOnOwnLine AsKeywordOnOwnLine

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

IncludeSemicolons IncludeSemicolons IncludeSemicolons

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

IndentationSize IndentationSize IndentationSize

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

IndentSetClause IndentSetClause IndentSetClause

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

IndentViewBody IndentViewBody IndentViewBody

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

KeywordCasing KeywordCasing KeywordCasing

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

MultilineInsertSourcesList MultilineInsertSourcesList MultilineInsertSourcesList

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

MultilineInsertTargetsList MultilineInsertTargetsList MultilineInsertTargetsList

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

MultilineSelectElementsList MultilineSelectElementsList MultilineSelectElementsList

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

MultilineSetClauseItems MultilineSetClauseItems MultilineSetClauseItems

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

MultilineViewColumnsList MultilineViewColumnsList MultilineViewColumnsList

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

MultilineWherePredicatesList MultilineWherePredicatesList MultilineWherePredicatesList

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

NewLineBeforeCloseParenthesisInMultilineList NewLineBeforeCloseParenthesisInMultilineList NewLineBeforeCloseParenthesisInMultilineList

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

NewLineBeforeFromClause NewLineBeforeFromClause NewLineBeforeFromClause

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

NewLineBeforeGroupByClause NewLineBeforeGroupByClause NewLineBeforeGroupByClause

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

NewLineBeforeHavingClause NewLineBeforeHavingClause NewLineBeforeHavingClause

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

NewLineBeforeJoinClause NewLineBeforeJoinClause NewLineBeforeJoinClause

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

NewLineBeforeOffsetClause NewLineBeforeOffsetClause NewLineBeforeOffsetClause

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

NewLineBeforeOpenParenthesisInMultilineList NewLineBeforeOpenParenthesisInMultilineList NewLineBeforeOpenParenthesisInMultilineList

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

NewLineBeforeOrderByClause NewLineBeforeOrderByClause NewLineBeforeOrderByClause

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

NewLineBeforeOutputClause NewLineBeforeOutputClause NewLineBeforeOutputClause

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

NewLineBeforeWhereClause NewLineBeforeWhereClause NewLineBeforeWhereClause

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

SqlEngineType SqlEngineType SqlEngineType

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

SqlVersion SqlVersion SqlVersion

Gets or sets the Sql version to generate script for

Methods

Reset() Reset() Reset()

Resets the options to their default value.

Applies to