Indexes Collection

Dieses Feature wird in einer zukünftigen Version von Microsoft SQL Server entfernt. Verwenden Sie dieses Feature beim Entwickeln neuer Anwendungen nicht, und planen Sie das Ändern von Anwendungen, in denen es zurzeit verwendet wird.

The Indexes collection contains Index objects that reference indexes that implement Microsoft SQL Server constraints and user-defined access paths.

Methods

Add Method	Refresh Method
Item Method	Remove Method (Collections)
ItemByID Method

Hinweise

With the Indexes collection, you can:

• Create a user-defined access path or unique constraint on data maintained by a SQL Server index.
• Remove a SQL Server index.

For more information about creating a SQL Server index using SQL-DMO, see Index Object.

To remove a SQL Server index:

• Use the Remove method of the Indexes collection, as in:

  oTables("Employees").Indexes.Remove("LastName")
  

When using the Item or Remove method, the Indexes collection supports member identification using either name or ordinal reference syntax. For example:

Set oIndex = oTable.Indexes("LastName")

Or

Set oIndex = oTable.Indexes(2)

Hinweis:
Creating or removing indexes by using the Indexes collection requires appropriate privilege. The SQL Server login used for SQLServer object connection must be a member of the fixed role db_ddladmin or a role with greater privilege.