CreateIndexStatement Class

Reference

Definition

Namespace:: Microsoft.SqlServer.TransactSql.ScriptDom

Assembly:: Microsoft.SqlServer.TransactSql.ScriptDom.dll

Package:: Microsoft.SqlServer.DacFx.x64 v140.3881.1

Package:: Microsoft.SqlServer.DacFx v150.5282.3

Package:: Microsoft.SqlServer.DacFx v160.6161.0

Package:: Microsoft.Data.Tools.Msbuild v10.0.61804.210

Package:: Microsoft.SqlServer.TransactSql.ScriptDom v161.8901.0

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

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: Object

TSqlFragment

TSqlStatement

IndexStatement
CreateIndexStatement

Attributes: SerializableAttribute

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

Share via