SqlScriptGeneratorOptions-Klasse

Controls the options for Sql Script Generation.

Vererbungshierarchie

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

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

Syntax

'Declaration
Public Class SqlScriptGeneratorOptions
'Usage
Dim instance As SqlScriptGeneratorOptions

public class SqlScriptGeneratorOptions

public ref class SqlScriptGeneratorOptions

type SqlScriptGeneratorOptions =  class end

public class SqlScriptGeneratorOptions

Der SqlScriptGeneratorOptions-Typ macht folgende Elemente verfügbar.

Konstruktoren

	Name	Beschreibung
	SqlScriptGeneratorOptions	Initializes a new instance of the SqlScriptGeneratorOptions class.

Zum Anfang

Eigenschaften

	Name	Beschreibung
	AlignClauseBodies	Gets or sets a value that indicates whether the bodies of FROM, WHERE, GROUP BY, clauses are aligned.
	AlignColumnDefinitionFields	Gets or sets a value that indicates whether column definition fields (column name, data type, constraints) are aligned into alignment columns.
	AlignSetClauseItem	Gets or sets a value that indicates whether the SET clause items in an UPDATE statement is aligned.
	AsKeywordOnOwnLine	Gets or sets a value that indicates whether the AS keyword is written on its own line.
	IncludeSemicolons	Gets or sets a value that indicates whether a semi colon is included after each statement.
	IndentationSize	Gets or sets the number of spaces to use when indenting text.
	IndentSetClause	Gets or sets a value that indicates whether the SET clause for an UPDATE statement is indented.
	IndentViewBody	Gets or sets a value that indicates whether the view statement body is indented.
	KeywordCasing	Gets or sets the keyword casing option to use during script generation.
	MultilineInsertSourcesList	Gets or sets a value that indicates whether the INSERT column sources list is spread across multiple lines.
	MultilineInsertTargetsList	Gets or sets a value that indicates whether the INSERT column targets list is spread across multiple lines.
	MultilineSelectElementsList	Gets or sets a value that indicates whether select elements are listed as multi-line list.
	MultilineSetClauseItems	Gets or sets a value that indicates whether the SET clause items are listed on multiple lines.
	MultilineViewColumnsList	Gets or sets a value that indicates whether the view statement columns are listed as a multi-line list.
	MultilineWherePredicatesList	Gets or sets a value that indicates whether WHERE predicates (expressions separated by AND, and OR) are written on multiple lines.
	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	Gets or sets a value that indicates whether a newline exists before the FROM clause in a SELECT statement.
	NewLineBeforeGroupByClause	Gets or sets a value that indicates whether a newline exists before the GROUP BY clause in a SELECT statement.
	NewLineBeforeHavingClause	Gets or sets a value that indicates whether a newline exists before the HAVING clause in a SELECT statement.
	NewLineBeforeJoinClause	Gets or sets a value that indicates whether a newline exists before the JOIN clause in a SELECT statement.
	NewLineBeforeOffsetClause	Gets or sets a value that indicates whether a newline exists before the OFFSET clause.
	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	Gets or sets a value that indicates whether a newline exists before the ORDER BY clause in a SELECT statement.
	NewLineBeforeOutputClause	Gets or sets a value that indicates whether a newline exists before the OUTPUT clause.
	NewLineBeforeWhereClause	Gets or sets a value that indicates whether a newline exists before the WHERE clause in a SELECT statement.
	SqlVersion	Gets or sets the Sql version to generate script for.

Zum Anfang

Methoden

	Name	Beschreibung
	Equals	(Geerbt von Object.)
	Finalize	(Geerbt von Object.)
	GetHashCode	(Geerbt von Object.)
	GetType	(Geerbt von Object.)
	MemberwiseClone	(Geerbt von Object.)
	Reset	Resets the options to their default value.
	ToString	(Geerbt von Object.)

Zum Anfang

Threadsicherheit

Alle öffentlichen static (Shared in Visual Basic)-Elemente dieses Typs sind Threadsicher. Für Instanzelemente wird die Threadsicherheit nicht gewährleistet.

Siehe auch

Verweis

Microsoft.SqlServer.TransactSql.ScriptDom-Namespace