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 네임스페이스