SqlScriptGeneratorOptions SqlScriptGeneratorOptions SqlScriptGeneratorOptions Class

Definition

Controls the options for Sql Script Generation.

public ref class SqlScriptGeneratorOptions
public class SqlScriptGeneratorOptions
Public Class SqlScriptGeneratorOptions
Inheritance
SqlScriptGeneratorOptionsSqlScriptGeneratorOptionsSqlScriptGeneratorOptions

Constructors

SqlScriptGeneratorOptions() SqlScriptGeneratorOptions() SqlScriptGeneratorOptions()

Initializes a new instance of the SqlScriptGeneratorOptions class.

Properties

AlignClauseBodies AlignClauseBodies AlignClauseBodies

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

AlignColumnDefinitionFields AlignColumnDefinitionFields AlignColumnDefinitionFields

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

AlignSetClauseItem AlignSetClauseItem AlignSetClauseItem

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

AsKeywordOnOwnLine AsKeywordOnOwnLine AsKeywordOnOwnLine

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

IncludeSemicolons IncludeSemicolons IncludeSemicolons

Gets or sets a value that indicates whether a semi colon is 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 value that indicates whether the SET clause for an UPDATE statement is indented.

IndentViewBody IndentViewBody IndentViewBody

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

KeywordCasing KeywordCasing KeywordCasing

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

MultilineInsertSourcesList MultilineInsertSourcesList MultilineInsertSourcesList

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

MultilineInsertTargetsList MultilineInsertTargetsList MultilineInsertTargetsList

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

MultilineSelectElementsList MultilineSelectElementsList MultilineSelectElementsList

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

MultilineSetClauseItems MultilineSetClauseItems MultilineSetClauseItems

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

MultilineViewColumnsList MultilineViewColumnsList MultilineViewColumnsList

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

MultilineWherePredicatesList MultilineWherePredicatesList MultilineWherePredicatesList

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

NewLineBeforeCloseParenthesisInMultilineList NewLineBeforeCloseParenthesisInMultilineList 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.

NewLineBeforeFromClause NewLineBeforeFromClause NewLineBeforeFromClause

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

NewLineBeforeGroupByClause NewLineBeforeGroupByClause NewLineBeforeGroupByClause

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

NewLineBeforeHavingClause NewLineBeforeHavingClause NewLineBeforeHavingClause

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

NewLineBeforeJoinClause NewLineBeforeJoinClause NewLineBeforeJoinClause

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

NewLineBeforeOffsetClause NewLineBeforeOffsetClause NewLineBeforeOffsetClause

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

NewLineBeforeOpenParenthesisInMultilineList NewLineBeforeOpenParenthesisInMultilineList 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.

NewLineBeforeOrderByClause NewLineBeforeOrderByClause NewLineBeforeOrderByClause

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

NewLineBeforeOutputClause NewLineBeforeOutputClause NewLineBeforeOutputClause

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

NewLineBeforeWhereClause NewLineBeforeWhereClause NewLineBeforeWhereClause

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

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