Indexes Collection

Diese Funktion wird in zukünftigen Versionen von Microsoft SQL Server nicht mehr bereitgestellt. Verwenden Sie diese Funktion 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.