IndexDefinition Class

Definition

Represents the base for index definitions.

[System.Serializable]
public class IndexDefinition : Microsoft.SqlServer.TransactSql.ScriptDom.TSqlStatement
[<System.Serializable>]
type IndexDefinition = class
    inherit TSqlStatement
Public Class IndexDefinition
Inherits TSqlStatement
Inheritance
Attributes

Constructors

IndexDefinition()

Fields

Uninitialized

Constant to indicate and uninitialized token.

(Inherited from TSqlFragment)

Properties

Columns

The defined columns.

FileStreamOn

Optional specification of the filestream. Can be either Identifier or String literal.

FilterPredicate

Optional filter predicate for index.

FirstTokenIndex

Gets or sets the first index of the token.

(Inherited from TSqlFragment)
FragmentLength

Defines the number of characters the fragment takes up in the script it was parsed.

(Inherited from TSqlFragment)
IncludeColumns

Non-key columns to be added to the leaf level of the nonclustered index.

IndexOptions

The index options. Optional may have zero elements.

IndexType

The index type.

LastTokenIndex

Gets or sets the last index of the token.

(Inherited from TSqlFragment)
Name

Index name.

OnFileGroupOrPartitionScheme

The filegroup or partition scheme. Might be null.

ScriptTokenStream

Gets or sets the script token stream.

(Inherited from TSqlFragment)
StartColumn

Gets the start column.

(Inherited from TSqlFragment)
StartLine

Gets the start line.

(Inherited from TSqlFragment)
StartOffset

Defines the character offset of fragments starting location in the script it was parsed.

(Inherited from TSqlFragment)
Unique

Shows if Unique keyword is used.

Methods

Accept(TSqlFragmentVisitor)

Accepts visitor

AcceptChildren(TSqlFragmentVisitor)

Accepts visitor for Children

Applies to