The IndexCollection class represents a collection of Index objects that represent all the indexes defined on the instance of SQL Server.

The following tables list the members exposed by the IndexCollection type.

 Protected Fields

	名称	Description
	initialized	This value supports the SMO infrastructure and is not intended to be used directly from your code. (inherited from AbstractCollectionBase)

顶部

 Public Properties

	名称	Description
	Count	Gets the number of objects in the referenced collection. (inherited from SmoCollectionBase)
	IsSynchronized	Gets the Boolean property value that specifies whether access to the collection is synchronized and therefore thread-safe. (inherited from SmoCollectionBase)
	Item	Overloaded. Gets an Index object in the collection by name or by index number.
	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. (inherited from SmoCollectionBase)

顶部

 Public Methods

(see also Protected Methods )

	名称	Description
	Add	Adds an Index object to the IndexCollection collection.
	Contains	(inherited from SimpleObjectCollectionBase )
	CopyTo	Copies the collection objects to a one-dimensional array beginning at the index value specified.
	Equals	Overloaded. (inherited from Object )
	GetEnumerator	Returns an IEnumerator interface that allows you to iterate through the objects in the collection. (inherited from SmoCollectionBase)
	GetHashCode	(inherited from Object )
	GetType	(inherited from Object )
	ItemById	Extracts a member from the IndexCollection collection using a system-defined, unique identifier.
	ReferenceEquals	(inherited from Object )
	Refresh	Overloaded. Refreshes the referenced collection. (inherited from SmoCollectionBase)
	Remove	Overloaded. Removes an Index object from the IndexCollection collection.
	ToString	(inherited from Object )

顶部

 Protected Methods

	名称	Description
	AddExisting	(inherited from AbstractCollectionBase )
	AddImpl	(inherited from SortedListCollectionBase )
	Finalize	(inherited from Object )
	GetCollectionElementType	Gets the Collection Element Type. (inherited from SmoCollectionBase)
	GetItemById	Overloaded. (inherited from SmoCollectionBase )
	GetObjectByIndex	(inherited from SmoCollectionBase )
	ImplAddExisting	(inherited from SortedListCollectionBase )
	InitializeChildCollection	Overloaded. Initializes the child collections of the referenced collection. (inherited from SmoCollectionBase)
	InitInnerCollection	Initializes the collection. (inherited from SimpleObjectCollectionBase)
	MemberwiseClone	(inherited from Object )
	ValidateParentObject	(inherited from SmoCollectionBase )

顶部

 Explicit Interface Implementations

	名称	Description
	System.Collections.ICollection.CopyTo	(inherited from SmoCollectionBase )

顶部

 请参阅

参考

IndexCollection Class
Microsoft.SqlServer.Management.Smo Namespace