UserDefinedFunctionCollection 类
The UserDefinedFunctionCollection class represents a collection of UserDefinedFunction objects that represent all the user-defined functions 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..::..UserDefinedFunctionCollection
命名空间： Microsoft.SqlServer.Management.Smo
程序集： Microsoft.SqlServer.Smo（在 Microsoft.SqlServer.Smo.dll 中）
语法
声明
Public NotInheritable Class UserDefinedFunctionCollection _
Inherits SchemaCollectionBase
用法
Dim instance As UserDefinedFunctionCollection
public sealed class UserDefinedFunctionCollection : SchemaCollectionBase
public ref class UserDefinedFunctionCollection sealed : public SchemaCollectionBase
[<SealedAttribute>]
type UserDefinedFunctionCollection =
class
inherit SchemaCollectionBase
end
public final class UserDefinedFunctionCollection extends SchemaCollectionBase
UserDefinedFunctionCollection 类型公开以下成员。
属性
| 名称 | 说明 | |
|---|---|---|
.gif "公共属性") |
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 UserDefinedFunction object in the collection by index number. |
|
Item[ ( [ ( String] ) ] ) | Gets a UserDefinedFunction object in the collection by name. |
|
Item[ ( [ ( String, String] ) ] ) | Gets a UserDefinedFunction object in the collection by name and schema. |
|
Parent | Gets the Database object that is the parent of the UserDefinedFunction object. |
|
SyncRoot | Gets an object that can be used to synchronize access to the collection. （从 SmoCollectionBase 继承。） |
页首
方法
| 名称 | 说明 | |
|---|---|---|
.gif "公共方法") |
Add | Adds a user-defined function to the collection. |
.gif "受保护方法") |
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 starting at the specidied index value. |
|
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 UserDefinedFunctionCollection collection by 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 继承。） |
页首
字段
| 名称 | 说明 | |
|---|---|---|
.gif "受保护字段") |
initialized | This value supports the SMO infrastructure and is not intended to be used directly from your code. （从 AbstractCollectionBase 继承。） |
页首
显式接口实现
| 名称 | 说明 | |
|---|---|---|
.gif "显式接口实现") .gif "私有方法") |
ICollection. . :: . .CopyTo | Copies the elements from an instance to an array beginning at the index indicated. （从 SmoCollectionBase 继承。） |
页首
注释
A UserDefinedFunctionCollection object can be used to gain access to a set of user-defined functions. You can use the Item property to return a specific UserDefinedFunction object.
Thread Safety
此类型的任何公共静态（Microsoft Visual Basic 中的 Shared）成员在多线程操作中是安全的。 不保证所有实例成员都对于线程安全的。
线程安全
此类型的任何公共 static（在 Visual Basic 中为 Shared） 成员都是线程安全的。不保证所有实例成员都是线程安全的。