Clase TriggerCollection
The TriggerCollection class represents a collection of Trigger objects that represent all the 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.TriggerCollection
Espacio de nombres: Microsoft.SqlServer.Management.Smo
Ensamblado: Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)
Sintaxis
'Declaración
Public Class TriggerCollection _
Inherits SimpleObjectCollectionBase
'Uso
Dim instance As TriggerCollection
public class TriggerCollection : SimpleObjectCollectionBase
public ref class TriggerCollection : public SimpleObjectCollectionBase
type TriggerCollection =
class
inherit SimpleObjectCollectionBase
end
public class TriggerCollection extends SimpleObjectCollectionBase
El tipo TriggerCollection 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 Trigger object in the collection by index number. |
|
Item[String] | Gets a Trigger object in the collection by name. |
|
Parent | Gets the Table object that is the parent of the Trigger 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 Trigger object to the TriggerCollection object. |
.gif "Método protegido") |
AddExisting | Adds an object to the collection. (Se hereda de AbstractCollectionBase.) |
|
AddImpl | Adds the specified object to this collection (Se hereda de SortedListCollectionBase.) |
|
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.) |
|
Finalize | (Se hereda de Object.) |
|
GetCollectionElementType | Gets the Element Type (Invalida SmoCollectionBase.GetCollectionElementType().) |
|
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.) |
|
GetItemById(Int32) | Extracts a member from the referenced collection using a system-defined, unique identifier. (Se hereda de SmoCollectionBase.) |
|
GetItemById(Int32, String) | Extracts a member from the referenced collection using a system-defined, unique identifier and name. (Se hereda de SmoCollectionBase.) |
|
GetObjectByIndex | Extracts a member from the referenced collection using a system-defined, unique identifier. (Se hereda de SmoCollectionBase.) |
|
GetType | (Se hereda de Object.) |
|
ImplAddExisting | Adds an existing specified object to this collection (Se hereda de SortedListCollectionBase.) |
|
InitializeChildCollection() | Initializes the child collections of the referenced collection. (Se hereda de SmoCollectionBase.) |
|
InitializeChildCollection(Boolean) | Initializes the child collections of the referenced collection with the option to refresh the properties of the referenced collection. (Se hereda de SmoCollectionBase.) |
|
InitInnerCollection | Initializes the collection. (Se hereda de SimpleObjectCollectionBase.) |
|
ItemById | Extracts a member from the TriggerCollection object using a system-defined, unique identifier. |
|
MemberwiseClone | (Se hereda de Object.) |
|
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.) |
|
Remove(String) | Removes a Trigger object from the TriggerCollection object. |
|
Remove(Trigger) | Removes a Trigger object from the TriggerCollection object. |
|
ToString | (Se hereda de Object.) |
|
ValidateParentObject | Validates the parent object exists. (Se hereda de SmoCollectionBase.) |
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 TriggerCollection object can be used to gain access to a set of triggers. You can use the Item property to return a specific Trigger 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.
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.
Vea también
Referencia
Espacio de nombres Microsoft.SqlServer.Management.Smo