Export (0) Print
Expand All

Index Class

The Index object represents a Microsoft SQL Server index.

Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

public sealed class Index : ScriptNameObjectBase, ICreatable, IDroppable, IMarkForDrop, 
	IAlterable, IRenamable, IExtendedProperties, IScriptable
public final class Index extends ScriptNameObjectBase implements ICreatable, IDroppable, 
	IMarkForDrop, IAlterable, IRenamable, IExtendedProperties, IScriptable
public final class Index extends ScriptNameObjectBase implements ICreatable, IDroppable, 
	IMarkForDrop, IAlterable, IRenamable, IExtendedProperties, IScriptable

This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.

To get Index object properties, users can be a member of the public fixed server role.

To set Index object properties, users must have ALTER permission on the parent table or view, or be a member of the db_owner or the db_ddladmin fixed database roles, or the sysadmin fixed server role.

To create or drop an index, users must have ALTER permission on the parent table or view, or be a member of the db_owner or the db_ddladmin fixed database roles, or the sysadmin fixed server role.

To update statistics on the index, users must have ALTER permission on the parent table or view, or be a member of the db_owner or the db_ddladmin fixed database roles, or the sysadmin fixed server role.

To rebuild, reorganize, or re-create the index, users must have ALTER permission on the parent table or view, or be a member of the db_owner or the db_ddladmin fixed database roles, or the sysadmin fixed server role.


Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft