Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

CreateIndexStatement Class

SQL Server 2012

Represents the create index statement.

Namespace:  Microsoft.SqlServer.TransactSql.ScriptDom
Assembly:  Microsoft.SqlServer.TransactSql.ScriptDom (in Microsoft.SqlServer.TransactSql.ScriptDom.dll)
[SerializableAttribute]
public class CreateIndexStatement : IndexStatement

The CreateIndexStatement type exposes the following members.

  NameDescription
Public methodCreateIndexStatementInitializes a new instance of the CreateIndexStatement class.
Top
  NameDescription
Public propertyClusteredGets or sets a value that indicates whether the Clustered keyword is used.
Public propertyColumnsGets the list of the defined columns.
Public propertyFileStreamOnGets or sets the file stream specification.
Public propertyFilterPredicateGets or sets the optional filter predicate for the index.
Public propertyFirstTokenIndexGets or sets the first token index. (Inherited from TSqlFragment.)
Public propertyFragmentLengthGets the fragment length. (Inherited from TSqlFragment.)
Public propertyIncludeColumnsGets the list of the include columns.
Public propertyIndexOptionsGets a list of index options. Optional may have zero elements. (Inherited from IndexStatement.)
Public propertyLastTokenIndexGets or sets the last token index. (Inherited from TSqlFragment.)
Public propertyNameGets the name of the index. (Inherited from IndexStatement.)
Public propertyOnFileGroupOrPartitionSchemeGets or sets the filegroup or partition scheme.
Public propertyOnNameGets or sets the table or view name that comes after the ON keyword. (Inherited from IndexStatement.)
Public propertyScriptTokenStreamGets or sets a list of token streams. (Inherited from TSqlFragment.)
Public propertyStartColumnGets the starting column. (Inherited from TSqlFragment.)
Public propertyStartLineGets the starting line. (Inherited from TSqlFragment.)
Public propertyStartOffsetGets the fragment start offset value. (Inherited from TSqlFragment.)
Public propertyTranslated80SyntaxTo90Gets or sets a value that indicates whether the 80 syntax was translated into 90.
Public propertyUniqueGets or sets a value that indicates whether the Unique keyword is used.
Top
  NameDescription
Public methodAcceptIndicates the entry point for a given visitor. (Overrides TSqlFragment.Accept(TSqlFragmentVisitor).)
Public methodAcceptChildrenAccepts visitor for Children. (Overrides IndexStatement.AcceptChildren(TSqlFragmentVisitor).)
Public methodEquals (Inherited from Object.)
Protected methodFinalize (Inherited from Object.)
Public methodGetHashCode (Inherited from Object.)
Public methodGetType (Inherited from Object.)
Protected methodMemberwiseClone (Inherited from Object.)
Public methodToString (Inherited from Object.)
Top
Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.