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

SqlScriptGeneratorOptions 유형에서 다음 멤버를 표시합니다.

  이름설명
공용 메서드SqlScriptGeneratorOptionsInitializes a new instance of the SqlScriptGeneratorOptions class.
맨 위로 이동

  이름설명
공용 속성AlignClauseBodiesGets or sets a value that indicates whether the bodies of FROM, WHERE, GROUP BY, clauses are aligned.
공용 속성AlignColumnDefinitionFieldsGets or sets a value that indicates whether column definition fields (column name, data type, constraints) are aligned into alignment columns.
공용 속성AlignSetClauseItemGets or sets a value that indicates whether the SET clause items in an UPDATE statement is aligned.
공용 속성AsKeywordOnOwnLineGets or sets a value that indicates whether the AS keyword is written on its own line.
공용 속성IncludeSemicolonsGets or sets a value that indicates whether a semi colon is included after each statement.
공용 속성IndentationSizeGets or sets the number of spaces to use when indenting text.
공용 속성IndentSetClauseGets or sets a value that indicates whether the SET clause for an UPDATE statement is indented.
공용 속성IndentViewBodyGets or sets a value that indicates whether the view statement body is indented.
공용 속성KeywordCasingGets or sets the keyword casing option to use during script generation.
공용 속성MultilineInsertSourcesListGets or sets a value that indicates whether the INSERT column sources list is spread across multiple lines.
공용 속성MultilineInsertTargetsListGets or sets a value that indicates whether the INSERT column targets list is spread across multiple lines.
공용 속성MultilineSelectElementsListGets or sets a value that indicates whether select elements are listed as multi-line list.
공용 속성MultilineSetClauseItemsGets or sets a value that indicates whether the SET clause items are listed on multiple lines.
공용 속성MultilineViewColumnsListGets or sets a value that indicates whether the view statement columns are listed as a multi-line list.
공용 속성MultilineWherePredicatesListGets or sets a value that indicates whether WHERE predicates (expressions separated by AND, and OR) are written on multiple lines.
공용 속성NewLineBeforeCloseParenthesisInMultilineListGets or sets a value that indicates whether a newline is placed before a close parenthesis when writing a multi-line list in parenthesis.
공용 속성NewLineBeforeFromClauseGets or sets a value that indicates whether a newline exists before the FROM clause in a SELECT statement.
공용 속성NewLineBeforeGroupByClauseGets or sets a value that indicates whether a newline exists before the GROUP BY clause in a SELECT statement.
공용 속성NewLineBeforeHavingClauseGets or sets a value that indicates whether a newline exists before the HAVING clause in a SELECT statement.
공용 속성NewLineBeforeJoinClauseGets or sets a value that indicates whether a newline exists before the JOIN clause in a SELECT statement.
공용 속성NewLineBeforeOffsetClauseGets or sets a value that indicates whether a newline exists before the OFFSET clause.
공용 속성NewLineBeforeOpenParenthesisInMultilineListGets or sets a value that indicates whether a newline is placed before an open parenthesis when writing a multi-line list in parenthesis.
공용 속성NewLineBeforeOrderByClauseGets or sets a value that indicates whether a newline exists before the ORDER BY clause in a SELECT statement.
공용 속성NewLineBeforeOutputClauseGets or sets a value that indicates whether a newline exists before the OUTPUT clause.
공용 속성NewLineBeforeWhereClauseGets or sets a value that indicates whether a newline exists before the WHERE clause in a SELECT statement.
공용 속성SqlVersionGets or sets the Sql version to generate script for.
맨 위로 이동

  이름설명
공용 메서드Equals (Object에서 상속됨)
보호된 메서드Finalize (Object에서 상속됨)
공용 메서드GetHashCode (Object에서 상속됨)
공용 메서드GetType (Object에서 상속됨)
보호된 메서드MemberwiseClone (Object에서 상속됨)
공용 메서드ResetResets the options to their default value.
공용 메서드ToString (Object에서 상속됨)
맨 위로 이동

이 유형의 모든 공용 static(Visual Basic에서는 Shared) 멤버는 스레드로부터 안전합니다. 인스턴스 멤버는 스레드로부터의 안전성이 보장되지 않습니다.

커뮤니티 추가 항목

추가
표시: