.png)
Index Class
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.
