StoredProcedureCollection Members
The StoredProcedureCollection class represents a collection of StoredProcedure objects that represent all the stored procedures defined on a table.
The following tables list the members exposed by the StoredProcedureCollection type.
Protected Fields
| 名稱 | Description | |
|---|---|---|
.gif "ms220354.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 "ms220354.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 a StoredProcedure object in the collection by name or by index number. |
|
Parent | Gets the Database object that is the parent of the StoredProcedure 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 "ms220354.pubmethod(zh-tw,SQL.90).gif") |
Contains | Overloaded. (inherited from SchemaCollectionBase ) |
|
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 StoredProcedureCollection collection using a system-defined, unique identifier. |
.gif "ms220354.static(zh-tw,SQL.90).gif") |
ReferenceEquals | (inherited from Object ) |
|
Refresh | Overloaded. Refreshes the referenced collection. (inherited from SmoCollectionBase) |
|
ToString | (inherited from Object ) |
頂端
Protected Methods
| 名稱 | Description | |
|---|---|---|
.gif "ms220354.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 SchemaCollectionBase) |
|
MemberwiseClone | (inherited from Object ) |
|
ValidateParentObject | (inherited from SmoCollectionBase ) |
頂端
Explicit Interface Implementations
| 名稱 | Description | |
|---|---|---|
| System.Collections.ICollection.CopyTo | (inherited from SmoCollectionBase ) |
頂端
請參閱
參考
StoredProcedureCollection Class
Microsoft.SqlServer.Management.Smo Namespace