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)
Syntax
'Declaration
Public NotInheritable Class Index
Inherits ScriptNameObjectBase
Implements ICreatable, IDroppable, IMarkForDrop, IAlterable, _
IRenamable, IExtendedProperties, IScriptable
public sealed class Index : ScriptNameObjectBase, ICreatable, IDroppable, IMarkForDrop,
IAlterable, IRenamable, IExtendedProperties, IScriptable
public ref class Index sealed : public 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
Hinweise
Der Namespace, die Klasse oder das Element wird nur in der Version 2.0 von Microsoft .NET Framework unterstützt.
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.
Inheritance Hierarchy
System.Object
Microsoft.SqlServer.Management.Smo.SmoObjectBase
Microsoft.SqlServer.Management.Smo.SqlSmoObject
Microsoft.SqlServer.Management.Smo.NamedSmoObject
Microsoft.SqlServer.Management.Smo.ScriptNameObjectBase
Microsoft.SqlServer.Management.Smo.Index
Beispiel
How to: Create a Non-Clustered, Composite Index in Visual Basic .NET
Threadsicherheit
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.
Plattformen
Entwicklungsplattformen
Eine Liste der unterstützten Plattformen finden Sie unterHardware- und Softwareanforderungen für die Installation von SQL Server 2005.
Zielplattforme
Eine Liste der unterstützten Plattformen finden Sie unterHardware- und Softwareanforderungen für die Installation von SQL Server 2005.
Siehe auch
Verweis
Index Members
Microsoft.SqlServer.Management.Smo Namespace
Andere Ressourcen
Creating, Altering, and Removing Indexes
Indizes
CREATE INDEX (Transact-SQL)