CreateIndexStatement Class

  • Article

Represents the CREATE INDEX statement.

Inheritance Hierarchy

System.Object
  Microsoft.Data.Schema.ScriptDom.Sql.TSqlFragment
    Microsoft.Data.Schema.ScriptDom.Sql.TSqlStatement
      Microsoft.Data.Schema.ScriptDom.Sql.IndexStatement
        Microsoft.Data.Schema.ScriptDom.Sql.CreateIndexStatement

Namespace:  Microsoft.Data.Schema.ScriptDom.Sql
Assembly:  Microsoft.Data.Schema.ScriptDom.Sql (in Microsoft.Data.Schema.ScriptDom.Sql.dll)

Syntax

'Declaration
<SerializableAttribute> _
Public Class CreateIndexStatement _
    Inherits IndexStatement _
    Implements IFileStreamSpecifier

[SerializableAttribute]
public class CreateIndexStatement : IndexStatement, 
    IFileStreamSpecifier

[SerializableAttribute]
public ref class CreateIndexStatement : public IndexStatement, 
    IFileStreamSpecifier

[<SerializableAttribute>]
type CreateIndexStatement =  
    class
        inherit IndexStatement
        interface IFileStreamSpecifier
    end

public class CreateIndexStatement extends IndexStatement implements IFileStreamSpecifier

The CreateIndexStatement type exposes the following members.

Constructors

  Name Description
Public method CreateIndexStatement Initializes a new instance of the CreateIndexStatement class.

Top

Properties

  Name Description
Public property Clustered Gets or sets whether the Clustered keyword is used.
Public property Columns Gets a list of the defined columns.
Public property FileStreamOn Gets or sets the file stream specification.
Public property FilterPredicate Gets or sets the optional filter predicate for the index.
Public property FirstTokenIndex Gets or sets the first token index. (Inherited from TSqlFragment.)
Public property FragmentLength Gets the fragment length. (Inherited from TSqlFragment.)
Public property IncludeColumns Gets a list of the include columns.
Public property IndexOptions Gets a list of index options. (Inherited from IndexStatement.)
Public property LastTokenIndex Gets or sets the last token index. (Inherited from TSqlFragment.)
Public property Name Gets or sets the index name. (Inherited from IndexStatement.)
Public property OnFileGroupOrPartitionScheme
Public property OnName Gets or sets the table or view name that comes after the ON keyword. (Inherited from IndexStatement.)
Public property ScriptTokenStream Gets or sets a list of token streams. (Inherited from TSqlFragment.)
Public property StartColumn Gets the starting column. (Inherited from TSqlFragment.)
Public property StartLine Gets the starting line. (Inherited from TSqlFragment.)
Public property StartOffset Gets the fragment start offset value. (Inherited from TSqlFragment.)
Public property Translated80SyntaxTo90 Gets or sets whether the 80 syntax was translated into 90.
Public property Unique Gets or sets whether the Unique keyword is used.

Top

Methods

  Name Description
Public method Accept Entry point for a given visitor. (Overrides TSqlFragment.Accept(TSqlFragmentVisitor).)
Public method AcceptChildren Calls Accept on the children with the given visitor. (Overrides IndexStatement.AcceptChildren(TSqlFragmentVisitor).)
Public method Equals Determines whether the specified Object is equal to the current Object. (Inherited from Object.)
Protected method Finalize Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.)
Public method GetHashCode Serves as a hash function for a particular type. (Inherited from Object.)
Public method GetType Gets the Type of the current instance. (Inherited from Object.)
Protected method MemberwiseClone Creates a shallow copy of the current Object. (Inherited from Object.)
Public method ToString Returns a string that represents the current object. (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.

See Also

Reference

Microsoft.Data.Schema.ScriptDom.Sql Namespace