Clase UserDefinedFunctionCollection
The UserDefinedFunctionCollection class represents a collection of UserDefinedFunction objects that represent all the user-defined functions that are defined on a table.
Jerarquía de herencia
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
Espacio de nombres: Microsoft.SqlServer.Management.Smo
Ensamblado: Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)
Sintaxis
'Declaración
Public NotInheritable Class UserDefinedFunctionCollection _
Inherits SchemaCollectionBase
'Uso
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
El tipo UserDefinedFunctionCollection expone los siguientes miembros.
Propiedades
| Nombre | Descripción | |
|---|---|---|
.gif "Propiedad pública") |
Count | Gets the number of objects in the referenced collection. (Se hereda de SmoCollectionBase.) |
|
IsSynchronized | Gets the Boolean property value that specifies whether access to the collection is synchronized and therefore thread-safe. (Se hereda de 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. (Se hereda de SmoCollectionBase.) |
Arriba
Métodos
| Nombre | Descripción | |
|---|---|---|
.gif "Método público") |
Add | Adds a user-defined function to the collection. |
.gif "Método protegido") |
AddExisting | Adds an object to the collection. (Se hereda de AbstractCollectionBase.) |
|
Contains(String) | Validates whether the parameter collection contains a member with a name equal to the specified string. (Se hereda de 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. (Se hereda de SchemaCollectionBase.) |
|
CopyTo | Copies the collection objects to a one-dimensional array starting at the specidied index value. |
|
Equals | (Se hereda de Object.) |
|
GetEnumerator | Returns an IEnumerator interface that allows you to iterate through the objects in the collection. (Se hereda de SmoCollectionBase.) |
|
GetHashCode | (Se hereda de Object.) |
|
GetType | (Se hereda de Object.) |
|
ItemById | Extracts a member from the UserDefinedFunctionCollection collection by using a system-defined, unique identifier. |
|
Refresh() | Refreshes the referenced collection. (Se hereda de SmoCollectionBase.) |
|
Refresh(Boolean) | Refreshes the referenced collection with the option to refresh child objects of the referenced collection. (Se hereda de SmoCollectionBase.) |
|
ToString | (Se hereda de Object.) |
Arriba
Campos
| Nombre | Descripción | |
|---|---|---|
.gif "Campo protegido") |
initialized | This value supports the SMO infrastructure and is not intended to be used directly from your code. (Se hereda de AbstractCollectionBase.) |
Arriba
Implementaciones de interfaces explícitas
| Nombre | Descripción | |
|---|---|---|
.gif "Implementación de interfaces explícitas") .gif "Método privado") |
ICollection.CopyTo | Copies the elements from an instance to an array beginning at the index indicated. (Se hereda de SmoCollectionBase.) |
Arriba
Comentarios
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
Todos los miembros estáticos (compartidos en Microsoft Visual Basic) públicos de este tipo son seguros para operaciones multiproceso. No se garantiza que los miembros de instancia sean seguros para subprocesos.
Ejemplos
Seguridad para subprocesos
Cualquier miembro público static (Shared en Visual Basic) de este tipo es seguro para subprocesos. No se garantiza que los miembros de instancia sean seguros para subprocesos.