Clase IndexCollection
The IndexCollection class represents a collection of Index objects that represent all the indexes defined on the instance of SQL Server.
Jerarquía de herencia
System.Object
Microsoft.SqlServer.Management.Smo.AbstractCollectionBase
Microsoft.SqlServer.Management.Smo.SmoCollectionBase
Microsoft.SqlServer.Management.Smo.SortedListCollectionBase
Microsoft.SqlServer.Management.Smo.SimpleObjectCollectionBase
Microsoft.SqlServer.Management.Smo.IndexCollection
Espacio de nombres: Microsoft.SqlServer.Management.Smo
Ensamblado: Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)
Sintaxis
'Declaración
Public NotInheritable Class IndexCollection _
Inherits SimpleObjectCollectionBase
'Uso
Dim instance As IndexCollection
public sealed class IndexCollection : SimpleObjectCollectionBase
public ref class IndexCollection sealed : public SimpleObjectCollectionBase
[<SealedAttribute>]
type IndexCollection =
class
inherit SimpleObjectCollectionBase
end
public final class IndexCollection extends SimpleObjectCollectionBase
El tipo IndexCollection expone los siguientes miembros.
Propiedades
| Nombre | Descripción | |
|---|---|---|
.gif "Propiedad pública") |
Count | Gets the number of objects in the referenced collection. (Se hereda de SmoCollectionBase.) |
|
IsSynchronized | Gets the Boolean property value that specifies whether access to the collection is synchronized and therefore thread-safe. (Se hereda de SmoCollectionBase.) |
|
Item[Int32] | Gets an Index object in the collection by index number. |
|
Item[String] | Gets an Index object in the collection by name. |
|
Parent | Gets the SqlSmoObject object that is the parent of the IndexCollection object. |
|
SyncRoot | Gets an object that can be used to synchronize access to the collection. (Se hereda de SmoCollectionBase.) |
Arriba
Métodos
| Nombre | Descripción | |
|---|---|---|
.gif "Método público") |
Add | Adds an Index object to the IndexCollection collection. |
.gif "Método protegido") |
AddExisting | Adds an object to the collection. (Se hereda de AbstractCollectionBase.) |
|
Contains | Verifies whether the specified object exists in the collection. (Se hereda de SimpleObjectCollectionBase.) |
|
CopyTo | Copies the collection objects to a one-dimensional array beginning at the index value specified. |
|
Equals | (Se hereda de Object.) |
|
GetEnumerator | Returns an IEnumerator interface that allows you to iterate through the objects in the collection. (Se hereda de SmoCollectionBase.) |
|
GetHashCode | (Se hereda de Object.) |
|
GetType | (Se hereda de Object.) |
|
ItemById | Extracts a member from the IndexCollection collection using a system-defined, unique identifier. |
|
Refresh() | Refreshes the referenced collection. (Se hereda de SmoCollectionBase.) |
|
Refresh(Boolean) | Refreshes the referenced collection with the option to refresh child objects of the referenced collection. (Se hereda de SmoCollectionBase.) |
|
Remove(String) | Removes an Index object from the IndexCollection collection. |
|
Remove(Index) | Removes an Index object from the IndexCollection collection. |
|
ToString | (Se hereda de Object.) |
Arriba
Campos
| Nombre | Descripción | |
|---|---|---|
.gif "Campo protegido") |
initialized | This value supports the SMO infrastructure and is not intended to be used directly from your code. (Se hereda de AbstractCollectionBase.) |
Arriba
Implementaciones de interfaces explícitas
| Nombre | Descripción | |
|---|---|---|
.gif "Implementación de interfaces explícitas") .gif "Método privado") |
ICollection.CopyTo | Copies the elements from an instance to an array beginning at the index indicated. (Se hereda de SmoCollectionBase.) |
Arriba
Comentarios
An IndexCollection object can be used to gain access to a set of indexes. You can use the Item property to return a specific Index object.
Thread Safety
Todos los miembros estáticos (compartidos en Microsoft Visual Basic) públicos de este tipo son seguros para operaciones multiproceso. No se garantiza que los miembros de instancia sean seguros para subprocesos.
Ejemplos
Seguridad para subprocesos
Cualquier miembro público static (Shared en Visual Basic) de este tipo es seguro para subprocesos. No se garantiza que los miembros de instancia sean seguros para subprocesos.