CreateIndexStatement Class

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
	CreateIndexStatement	Initializes a new instance of the CreateIndexStatement class.

Top

Properties

	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.

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.)
	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.

See Also

Reference

Microsoft.SqlServer.TransactSql.ScriptDom Namespace