Clase DatabaseDdlTriggerCollection
The DatabaseDdlTriggerCollection class represents a collection of DatabaseDdlTrigger objects that represent all the database data definition language (DDL) triggers 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.SimpleObjectCollectionBase
Microsoft.SqlServer.Management.Smo.DatabaseDdlTriggerCollection
Espacio de nombres: Microsoft.SqlServer.Management.Smo
Ensamblado: Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)
Sintaxis
'Declaración
Public NotInheritable Class DatabaseDdlTriggerCollection _
Inherits SimpleObjectCollectionBase
'Uso
Dim instance As DatabaseDdlTriggerCollection
public sealed class DatabaseDdlTriggerCollection : SimpleObjectCollectionBase
public ref class DatabaseDdlTriggerCollection sealed : public SimpleObjectCollectionBase
[<SealedAttribute>]
type DatabaseDdlTriggerCollection =
class
inherit SimpleObjectCollectionBase
end
public final class DatabaseDdlTriggerCollection extends SimpleObjectCollectionBase
El tipo DatabaseDdlTriggerCollection 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 DatabaseDdlTriggerCollection object in the collection by index number. |
|
Item[String] | Gets a DatabaseDdlTrigger object in the collection by name. |
|
Parent | Gets the Database object that is the parent of the DatabaseDdlTriggerCollection 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 database data definition language (DDL) trigger to a table. |
.gif "Método protegido") |
AddExisting | Adds an object to the collection. (Se hereda de AbstractCollectionBase.) |
|
Contains | Verifies whether the specified object exists in the collection. (Se hereda de SimpleObjectCollectionBase.) |
|
CopyTo | Copies the collection objects to a one-dimensional array beginning at the index value specified. |
|
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 DatabaseDdlTriggerCollection collection 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 DatabaseDdlTriggerCollection object can be used to gain access to a set of database DDL triggers. You can use the Item property to return a specific DatabaseDdlTrigger 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.