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) 멤버는 스레드로부터 안전합니다. 인스턴스 멤버는 스레드로부터의 안전성이 보장되지 않습니다.