CreateIndexStatement Class
Represents the create index statement.
Assembly: Microsoft.SqlServer.TransactSql.ScriptDom (in Microsoft.SqlServer.TransactSql.ScriptDom.dll)
Microsoft.SqlServer.TransactSql.ScriptDom.TSqlFragment
Microsoft.SqlServer.TransactSql.ScriptDom.TSqlStatement
Microsoft.SqlServer.TransactSql.ScriptDom.IndexStatement
Microsoft.SqlServer.TransactSql.ScriptDom.CreateIndexStatement
| Name | Description | |
|---|---|---|
 | CreateIndexStatement() | Initializes a new instance of the CreateIndexStatement class. |
| Name | Description | |
|---|---|---|
 | Clustered | Gets or sets a value that indicates whether the Clustered keyword is used. |
| Columns | Gets the list of the defined columns. |
| FileStreamOn | Gets or sets the file stream specification. |
| FilterPredicate | Gets or sets the optional filter predicate for the index. |
| FirstTokenIndex | Gets or sets the first token index.(Inherited from TSqlFragment.) |
| FragmentLength | Gets the fragment length.(Inherited from TSqlFragment.) |
| IncludeColumns | Gets the list of the include columns. |
| IndexOptions | Gets a list of index options. Optional may have zero elements.(Inherited from IndexStatement.) |
| LastTokenIndex | Gets or sets the last token index.(Inherited from TSqlFragment.) |
| Name | Gets the name of the index.(Inherited from IndexStatement.) |
| OnFileGroupOrPartitionScheme | Gets or sets the filegroup or partition scheme. |
| OnName | Gets or sets the table or view name that comes after the ON keyword.(Inherited from IndexStatement.) |
| ScriptTokenStream | Gets or sets a list of token streams.(Inherited from TSqlFragment.) |
| StartColumn | Gets the starting column.(Inherited from TSqlFragment.) |
| StartLine | Gets the starting line.(Inherited from TSqlFragment.) |
| StartOffset | Gets the fragment start offset value.(Inherited from TSqlFragment.) |
| Translated80SyntaxTo90 | Gets or sets a value that indicates whether the 80 syntax was translated into 90. |
| Unique | Gets or sets a value that indicates whether the Unique keyword is used. |
| Name | Description | |
|---|---|---|
| Accept(TSqlFragmentVisitor) | Indicates the entry point for a given visitor.(Overrides TSqlFragment.Accept(TSqlFragmentVisitor).) |
| AcceptChildren(TSqlFragmentVisitor) | Accepts visitor for Children.(Overrides IndexStatement.AcceptChildren(TSqlFragmentVisitor).) |
| Equals(Object) | (Inherited from Object.) |
 | Finalize() | (Inherited from Object.) |
| GetHashCode() | (Inherited from Object.) |
| GetType() | (Inherited from Object.) |
| MemberwiseClone() | (Inherited from Object.) |
| ToString() | (Inherited from Object.) |
Any public static ( Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.