IndexCollection Members
The IndexCollection class represents a collection of Index objects that represent all the indexes defined on the instance of Microsoft SQL Server.
The following tables list the members exposed by the IndexCollection type.
Protected Fields
| 名稱 | Description | |
|---|---|---|
.gif "ms219626.protfield(zh-tw,SQL.90).gif") |
initialized | This value supports the SQL Server Management Objects infrastructure and is not intended to be used directly from your code. (inherited from AbstractCollectionBase) |
頂端
Public Properties
| 名稱 | Description | |
|---|---|---|
.gif "ms219626.pubproperty(zh-tw,SQL.90).gif") |
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 | |
|---|---|---|
.gif "ms219626.pubmethod(zh-tw,SQL.90).gif") |
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. |
.gif "ms219626.static(zh-tw,SQL.90).gif") |
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 | |
|---|---|---|
.gif "ms219626.protmethod(zh-tw,SQL.90).gif") |
AddExisting | (inherited from AbstractCollectionBase ) |
|
AddImpl | (inherited from SortedListCollectionBase ) |
|
Finalize | (inherited from Object ) |
|
GetCollectionElementType | Returns the type of object that the collection consists of. (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