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 命名空间