This topic has not yet been rated - Rate this topic

AlterIndexStatement Class

SQL Server 2012

Represents the alter index statement.

System.Object
  Microsoft.SqlServer.TransactSql.ScriptDom.TSqlFragment
    Microsoft.SqlServer.TransactSql.ScriptDom.TSqlStatement
      Microsoft.SqlServer.TransactSql.ScriptDom.IndexStatement
        Microsoft.SqlServer.TransactSql.ScriptDom.AlterIndexStatement

Namespace: Microsoft.SqlServer.TransactSql.ScriptDom
Assembly: Microsoft.SqlServer.TransactSql.ScriptDom (in Microsoft.SqlServer.TransactSql.ScriptDom.dll)

Syntax

C++

JScript

[SerializableAttribute]
public class AlterIndexStatement : IndexStatement

The AlterIndexStatement type exposes the following members.

Constructors

	Name	Description
	AlterIndexStatement	Initializes a new instance of the AlterIndexStatement class.

Top

Properties

	Name	Description
	All	Gets or sets a value that indicates whether All keyword is used.
	AlterIndexType	Gets or sets the type of the alter index statement.
	FirstTokenIndex	Gets or sets the first token index. (Inherited from TSqlFragment.)
	FragmentLength	Gets the fragment length. (Inherited from TSqlFragment.)
	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.)
	OnName	Gets or sets the table or view name that comes after the ON keyword. (Inherited from IndexStatement.)
	Partition	Gets or sets the expression that shows the partition. Optional, may be null.
	PromotedPaths	Gets or sets a collection of promoted paths.
	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.)
	XmlNamespaces	Gets or sets XML namespaces. May be null.

Top

Methods

	Name	Description
	Accept	Accepts 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.

Reference

Microsoft.SqlServer.TransactSql.ScriptDom Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD