StoredProcedureCollection 类
The StoredProcedureCollection class represents a collection of StoredProcedure objects that represent all the stored procedures that are defined on a table.
继承层次结构
System. . :: . .Object
Microsoft.SqlServer.Management.Smo. . :: . .AbstractCollectionBase
Microsoft.SqlServer.Management.Smo. . :: . .SmoCollectionBase
Microsoft.SqlServer.Management.Smo. . :: . .SortedListCollectionBase
Microsoft.SqlServer.Management.Smo. . :: . .SchemaCollectionBase
Microsoft.SqlServer.Management.Smo..::..StoredProcedureCollection
命名空间: Microsoft.SqlServer.Management.Smo
程序集: Microsoft.SqlServer.Smo(在 Microsoft.SqlServer.Smo.dll 中)
语法
声明
Public NotInheritable Class StoredProcedureCollection _
Inherits SchemaCollectionBase
用法
Dim instance As StoredProcedureCollection
public sealed class StoredProcedureCollection : SchemaCollectionBase
public ref class StoredProcedureCollection sealed : public SchemaCollectionBase
[<SealedAttribute>]
type StoredProcedureCollection =
class
inherit SchemaCollectionBase
end
public final class StoredProcedureCollection extends SchemaCollectionBase
StoredProcedureCollection 类型公开以下成员。
属性
名称 | 说明 | |
---|---|---|
![]() |
Count | Gets the number of objects in the referenced collection. (从 SmoCollectionBase 继承。) |
![]() |
IsSynchronized | Gets the Boolean property value that specifies whether access to the collection is synchronized and therefore thread-safe. (从 SmoCollectionBase 继承。) |
![]() |
Item[ ( [ ( Int32] ) ] ) | Gets a StoredProcedure object in the collection by index number. |
![]() |
Item[ ( [ ( String] ) ] ) | Gets a StoredProcedure object in the collection by name. |
![]() |
Item[ ( [ ( String, String] ) ] ) | Gets a StoredProcedure object in the collection by name and schema. |
![]() |
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. (从 SmoCollectionBase 继承。) |
页首
方法
名称 | 说明 | |
---|---|---|
![]() |
Add | Adds a stored procedure to the collection. |
![]() |
AddExisting | Adds an object to the collection. (从 AbstractCollectionBase 继承。) |
![]() |
AddImpl | Adds the specified object to this collection (从 SortedListCollectionBase 继承。) |
![]() |
Contains(String) | Validates whether the parameter collection contains a member with a name equal to the specified string. (从 SchemaCollectionBase 继承。) |
![]() |
Contains(String, String) | Validates whether the parameter collection contains a member with a name equal to the specified string and with the specified schema. (从 SchemaCollectionBase 继承。) |
![]() |
CopyTo | Copies the collection objects to a one-dimensional array beginning at the index value specified. |
![]() |
Equals | (从 Object 继承。) |
![]() |
Finalize | (从 Object 继承。) |
![]() |
GetCollectionElementType | Gets the Collection Element Type. (从 SmoCollectionBase 继承。) |
![]() |
GetEnumerator | Returns an IEnumerator interface that allows you to iterate through the objects in the collection. (从 SmoCollectionBase 继承。) |
![]() |
GetHashCode | (从 Object 继承。) |
![]() |
GetItemById(Int32) | Extracts a member from the referenced collection using a system-defined, unique identifier. (从 SmoCollectionBase 继承。) |
![]() |
GetItemById(Int32, String) | Extracts a member from the referenced collection using a system-defined, unique identifier and name. (从 SmoCollectionBase 继承。) |
![]() |
GetObjectByIndex | Extracts a member from the referenced collection using a system-defined, unique identifier. (从 SmoCollectionBase 继承。) |
![]() |
GetType | (从 Object 继承。) |
![]() |
ImplAddExisting | Adds an existing specified object to this collection (从 SortedListCollectionBase 继承。) |
![]() |
InitializeChildCollection() () () () | Initializes the child collections of the referenced collection. (从 SmoCollectionBase 继承。) |
![]() |
InitializeChildCollection(Boolean) | Initializes the child collections of the referenced collection with the option to refresh the properties of the referenced collection. (从 SmoCollectionBase 继承。) |
![]() |
InitInnerCollection | Initializes the collection. (从 SchemaCollectionBase 继承。) |
![]() |
ItemById | Extracts a member from the StoredProcedureCollection collection using a system-defined, unique identifier. |
![]() |
MemberwiseClone | (从 Object 继承。) |
![]() |
Refresh() () () () | Refreshes the referenced collection. (从 SmoCollectionBase 继承。) |
![]() |
Refresh(Boolean) | Refreshes the referenced collection with the option to refresh child objects of the referenced collection. (从 SmoCollectionBase 继承。) |
![]() |
ToString | (从 Object 继承。) |
![]() |
ValidateParentObject | Validates the parent object exists. (从 SmoCollectionBase 继承。) |
页首
字段
名称 | 说明 | |
---|---|---|
![]() |
initialized | This value supports the SMO infrastructure and is not intended to be used directly from your code. (从 AbstractCollectionBase 继承。) |
页首
显式接口实现
名称 | 说明 | |
---|---|---|
![]() ![]() |
ICollection. . :: . .CopyTo | Copies the elements from an instance to an array beginning at the index indicated. (从 SmoCollectionBase 继承。) |
页首
注释
A StoredProcedureCollection object can be used to gain access to a set of stored procedures. You can use the Item()()()() property to return a specific StoredProcedure object.
Thread Safety
此类型的任何公共静态(Microsoft Visual Basic 中的 Shared)成员在多线程操作中是安全的。 不保证所有实例成员都对于线程安全的。
线程安全
此类型的任何公共 static(在 Visual Basic 中为 Shared) 成员都是线程安全的。不保证所有实例成员都是线程安全的。