CreateIndexStatement CreateIndexStatement CreateIndexStatement Class


Represents the create index statement.

public ref class CreateIndexStatement : Microsoft::SqlServer::TransactSql::ScriptDom::IndexStatement
public class CreateIndexStatement : Microsoft.SqlServer.TransactSql.ScriptDom.IndexStatement
Public Class CreateIndexStatement
Inherits IndexStatement


CreateIndexStatement() CreateIndexStatement() CreateIndexStatement()

Initializes a new instance of the CreateIndexStatement class.


Clustered Clustered Clustered

Gets or sets a value that indicates whether the Clustered keyword is used.

Columns Columns Columns

Gets the list of the defined columns.

FileStreamOn FileStreamOn FileStreamOn

Gets or sets the file stream specification.

FilterPredicate FilterPredicate FilterPredicate

Gets or sets the optional filter predicate for the index.

FirstTokenIndex FirstTokenIndex FirstTokenIndex

Gets or sets the first token index.

(Inherited from TSqlFragment)
FragmentLength FragmentLength FragmentLength

Gets the fragment length.

(Inherited from TSqlFragment)
IncludeColumns IncludeColumns IncludeColumns

Gets the list of the include columns.

IndexOptions IndexOptions IndexOptions

Gets a list of index options. Optional may have zero elements.

(Inherited from IndexStatement)
LastTokenIndex LastTokenIndex LastTokenIndex

Gets or sets the last token index.

(Inherited from TSqlFragment)
Name Name Name

Gets the name of the index.

(Inherited from IndexStatement)
OnFileGroupOrPartitionScheme OnFileGroupOrPartitionScheme OnFileGroupOrPartitionScheme

Gets or sets the filegroup or partition scheme.

OnName OnName OnName

Gets or sets the table or view name that comes after the ON keyword.

(Inherited from IndexStatement)
ScriptTokenStream ScriptTokenStream ScriptTokenStream

Gets or sets a list of token streams.

(Inherited from TSqlFragment)
StartColumn StartColumn StartColumn

Gets the starting column.

(Inherited from TSqlFragment)
StartLine StartLine StartLine

Gets the starting line.

(Inherited from TSqlFragment)
StartOffset StartOffset StartOffset

Gets the fragment start offset value.

(Inherited from TSqlFragment)
Translated80SyntaxTo90 Translated80SyntaxTo90 Translated80SyntaxTo90

Gets or sets a value that indicates whether the 80 syntax was translated into 90.

Unique Unique Unique

Gets or sets a value that indicates whether the Unique keyword is used.


Accept(TSqlFragmentVisitor) Accept(TSqlFragmentVisitor) Accept(TSqlFragmentVisitor)

Indicates the entry point for a given visitor.

AcceptChildren(TSqlFragmentVisitor) AcceptChildren(TSqlFragmentVisitor) AcceptChildren(TSqlFragmentVisitor)

Accepts visitor for Children.


Uninitialized Uninitialized Uninitialized

Value is -1.

(Inherited from TSqlFragment)

Applies to