CreateIndexStatement Class

Definition

Represents the create index statement.

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

Constructors

CreateIndexStatement()

Fields

Uninitialized

Constant to indicate and uninitialized token.

(Inherited from TSqlFragment)

Properties

Clustered

Shows if Clustered keyword is used.

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

The include columns.

IndexOptions

The index options. Optional may have zero elements.

(Inherited from IndexStatement)
LastTokenIndex

Gets or sets the last index of the token.

(Inherited from TSqlFragment)
Name

The name of the index.

(Inherited from IndexStatement)
OnFileGroupOrPartitionScheme

The filegroup or partition scheme. Might be null.

OnName

The table or view name that comes after the ON keyword.

(Inherited from IndexStatement)
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)
Translated80SyntaxTo90

True if the 80 syntax was translated into 90 If this is false and there are index options present, then this statement must be a TSql90 statement However, 80 syntax is still being accepted in SQL 2005...

Unique

Shows if Unique keyword is used.

Methods

Accept(TSqlFragmentVisitor)

Accepts visitor

AcceptChildren(TSqlFragmentVisitor)

Accepts visitor for Children

Applies to