Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Represents the create index statement.
Inheritance Hierarchy
System.Object
Microsoft.SqlServer.TransactSql.ScriptDom.TSqlFragment
Microsoft.SqlServer.TransactSql.ScriptDom.TSqlStatement
Microsoft.SqlServer.TransactSql.ScriptDom.IndexStatement
Microsoft.SqlServer.TransactSql.ScriptDom.CreateIndexStatement
Namespace: Microsoft.SqlServer.TransactSql.ScriptDom
Assembly: Microsoft.SqlServer.TransactSql.ScriptDom (in Microsoft.SqlServer.TransactSql.ScriptDom.dll)
Syntax
'Declaration
<SerializableAttribute> _
Public Class CreateIndexStatement _
Inherits IndexStatement
'Usage
Dim instance As CreateIndexStatement
[SerializableAttribute]
public class CreateIndexStatement : IndexStatement
[SerializableAttribute]
public ref class CreateIndexStatement : public IndexStatement
[<SerializableAttribute>]
type CreateIndexStatement =
class
inherit IndexStatement
end
public class CreateIndexStatement extends IndexStatement
The CreateIndexStatement type exposes the following members.
Constructors
| Name | Description | |
|---|---|---|
.gif "Public method") |
CreateIndexStatement | Initializes a new instance of the CreateIndexStatement class. |
Top
Properties
| Name | Description | |
|---|---|---|
.gif "Public property") |
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. |
Top
Methods
| Name | Description | |
|---|---|---|
|
Accept | Indicates the entry point for a given visitor. (Overrides TSqlFragment.Accept(TSqlFragmentVisitor).) |
|
AcceptChildren | Accepts visitor for Children. (Overrides IndexStatement.AcceptChildren(TSqlFragmentVisitor).) |
|
Equals | (Inherited from Object.) |
.gif "Protected method") |
Finalize | (Inherited from Object.) |
|
GetHashCode | (Inherited from Object.) |
|
GetType | (Inherited from Object.) |
|
MemberwiseClone | (Inherited from Object.) |
|
ToString | (Inherited from Object.) |
Top
Thread Safety
Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.