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) 成员都是线程安全的。不保证所有实例成员都是线程安全的。