SqlScriptGeneratorOptions 类

Controls the options for Sql Script Generation.

继承层次结构

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

命名空间：  Microsoft.SqlServer.TransactSql.ScriptDom
程序集：  Microsoft.SqlServer.TransactSql.ScriptDom（在 Microsoft.SqlServer.TransactSql.ScriptDom.dll 中）

语法

声明
Public Class SqlScriptGeneratorOptions
用法
Dim instance As SqlScriptGeneratorOptions

public class SqlScriptGeneratorOptions

public ref class SqlScriptGeneratorOptions

type SqlScriptGeneratorOptions =  class end

public class SqlScriptGeneratorOptions

SqlScriptGeneratorOptions 类型公开以下成员。

构造函数

	名称	说明
	SqlScriptGeneratorOptions	Initializes a new instance of the SqlScriptGeneratorOptions class.

页首

属性

	名称	说明
	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.

页首

方法

	名称	说明
	Equals	（从 Object 继承。）
	Finalize	（从 Object 继承。）
	GetHashCode	（从 Object 继承。）
	GetType	（从 Object 继承。）
	MemberwiseClone	（从 Object 继承。）
	Reset	Resets the options to their default value.
	ToString	（从 Object 继承。）

页首

线程安全

此类型的任何公共 static（在 Visual Basic 中为 Shared） 成员都是线程安全的。不保证所有实例成员都是线程安全的。

请参阅

参考

Microsoft.SqlServer.TransactSql.ScriptDom 命名空间