Export (0) Print
Expand All

Trigger Class

The Trigger object represents a SQL Server trigger.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

'Declaration
<PhysicalFacetAttribute(PhysicalFacetOptions.ReadOnly)> _
<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)> _
Public NotInheritable Class Trigger _
	Inherits ScriptNameObjectBase _
	Implements ISfcSupportsDesignMode, ICreatable, IAlterable, IDroppable,  _
	IMarkForDrop, IExtendedProperties, IScriptable, ITextObject
'Usage
Dim instance As Trigger

The Trigger type exposes the following members.

  NameDescription
Public methodTriggerInitializes a new instance of the Trigger class.
Public methodTrigger(SqlSmoObject, String)Initializes a new instance of the Trigger class on the specified object, and with the specified name.
Top

  NameDescription
Public propertyAnsiNullsStatusGets the Boolean property value that specifies whether ISO NULL handling is enabled in the trigger.
Public propertyAssemblyNameGets or sets the name of the .NET assembly that is required by the referenced trigger.
Public propertyClassNameGets or sets the name of the class that is called by the referenced trigger.
Public propertyCreateDateGets the date and time when the trigger was created.
Public propertyDateLastModifiedGets the date and time when the trigger was last modified.
Public propertyDeleteGets or sets the Boolean property value that specifies whether the trigger is executed when records are deleted from the table.
Public propertyDeleteOrderGets or sets the order in which the trigger and the delete operation are executed.
Public propertyEventsGets the events that are associated with the trigger.
Public propertyExecutionContextGets or sets the execution context.
Public propertyExecutionContextPrincipalGets or sets the execution context principal.
Public propertyExtendedPropertiesGets the extended properties of the Trigger object.
Public propertyIDGets the ID value that uniquely identifies the trigger.
Public propertyImplementationTypeGets or sets the implementation type of the trigger.
Public propertyInsertGets or sets the Boolean property value that specifies whether the trigger is fired when records are inserted into the table.
Public propertyInsertOrderGets or sets the order in which the trigger and the insert operation are executed.
Public propertyInsteadOfGets or sets a Boolean property that specifies whether the trigger runs instead of the insert, delete, or update operation.
Public propertyIsEnabledGets or sets the Boolean property that specifies whether the trigger is enabled.
Public propertyIsEncryptedGets or sets the Boolean property value that specifies whether the trigger is encrypted.
Public propertyIsSystemObjectGets the Boolean property value that specifies whether the trigger is a system object.
Public propertyMethodNameGets the method name for the trigger.
Public propertyNameGets or sets a String value that specifies the name of the trigger. (Overrides NamedSmoObject.Name.)
Public propertyNotForReplicationGets or sets a Boolean property value that specifies whether the trigger is included in replication operations.
Public propertyParentGets or sets the SqlSmoObject object that is the parent of the Trigger object.
Public propertyPropertiesGets a collection of Property objects that represent the object properties. (Inherited from SqlSmoObject.)
Public propertyQuotedIdentifierStatusGets or sets a Boolean property value that specifies whether identifiers delimited by double quotation marks are Transact-SQL reserved keywords or contain characters not usually allowed by the Transact-SQL syntax rules.
Public propertyStateGets the state of the referenced object. (Inherited from SmoObjectBase.)
Public propertyTextBodyGets or sets the Transact-SQL string that defines the trigger.
Public propertyTextHeaderGets or sets the header part of the Transact-SQL string that defines the trigger.
Public propertyTextModeGets or sets the Boolean property that specifies whether the text header is editable as text.
Public propertyUpdateGets or sets the Boolean property value that specifies whether the trigger is fired when records are updated in the table.
Public propertyUpdateOrderGets or sets the order in which the trigger and the update operation are executed.
Public propertyUrnGets the Uniform Resource Name (URN) address value that uniquely identifies the object. (Inherited from SqlSmoObject.)
Public propertyUserDataGets or sets user-defined data associated with the referenced object. (Inherited from SmoObjectBase.)
Top

  NameDescription
Public methodAlterUpdates any Trigger object property changes on instance of Microsoft SQL Server . 
Public methodCreateCreates a trigger on the instance of SQL Server as defined by the Trigger object.
Public methodDiscoverDiscovers a list of type Object. (Inherited from SqlSmoObject.)
Public methodDropRemoves the trigger from the instance of SQL Server .
Public methodEquals (Inherited from Object.)
Protected methodFormatSqlVariantFormats an object as SqlVariant type. (Inherited from SqlSmoObject.)
Protected methodGetContextDBGets the context database that is associated with this object. (Inherited from SqlSmoObject.)
Protected methodGetDBNameGets the database name that is associated with the object. (Inherited from SqlSmoObject.)
Public methodGetHashCode (Inherited from Object.)
Protected methodGetPropValueGets a property value of the SqlSmoObject object. (Inherited from SqlSmoObject.)
Protected methodGetPropValueOptionalGets a property value of the SqlSmoObject object. (Inherited from SqlSmoObject.)
Protected methodGetPropValueOptionalAllowNullGets a property value of the SqlSmoObject object. (Inherited from SqlSmoObject.)
Protected methodGetServerObjectGets the server of the SqlSmoObject object. (Inherited from SqlSmoObject.)
Public methodGetType (Inherited from Object.)
Public methodInitializeInitializes the object and forces the properties be loaded. (Inherited from SqlSmoObject.)
Public methodInitialize(Boolean)Initializes the object and forces the properties be loaded. (Inherited from SqlSmoObject.)
Protected methodIsObjectInitializedVerifies whether the object has been initialized. (Inherited from SqlSmoObject.)
Protected methodIsObjectInSpaceVerifies whether the object is isolated or connected to the instance of SQL Server. (Inherited from SqlSmoObject.)
Public methodMarkForDropMarks the trigger to be dropped.
Public methodReCompileReferencesRecompiles any stored procedure or trigger that depends on the base SMO object.
Public methodRefreshRefreshes the script name. (Inherited from ScriptNameObjectBase.)
Public methodScriptGenerates a Transact-SQL script that can be used to re-create the trigger.
Public methodScript(ScriptingOptions)Generates a Transact-SQL script that can be used to re-create the trigger as specified by the script options.
Public methodScriptHeaderReturns the text header with the option to modify the text.
Protected methodSetParentImplSets the parent of the SqlSmoObject to the newParent parameter. (Inherited from SqlSmoObject.)
Public methodToStringReturns a String that represents the referenced object. (Inherited from SqlSmoObject.)
Public methodValidateValidates the state of an object. (Inherited from SmoObjectBase.)
Top

  NameDescription
Public eventPropertyChangedRepresents the event that occurs when a property is changed. (Inherited from SqlSmoObject.)
Public eventPropertyMetadataChangedRepresents the event that occurs when property metadata changes. (Inherited from SqlSmoObject.)
Top

  NameDescription
Explicit interface implemetationPrivate methodIAlienObject.DiscoverDiscovers any dependencies. Do not reference this member directly in your code. It supports the SQL Server infrastructure. (Inherited from SqlSmoObject.)
Explicit interface implemetationPrivate methodIAlienObject.GetDomainRootReturns the root of the domain. (Inherited from SqlSmoObject.)
Explicit interface implemetationPrivate methodIAlienObject.GetParentGets the parent of this object. Do not reference this member directly in your code. It supports the SQL Server infrastructure. (Inherited from SqlSmoObject.)
Explicit interface implemetationPrivate methodIAlienObject.GetPropertyTypeGets the type of the specified property. (Inherited from SqlSmoObject.)
Explicit interface implemetationPrivate methodIAlienObject.GetPropertyValueGets the value of the specified property. (Inherited from SqlSmoObject.)
Explicit interface implemetationPrivate methodIAlienObject.GetUrnGets the Unified Resource Name (URN) of the object. Do not reference this member directly in your code. It supports the SQL Server infrastructure. (Inherited from SqlSmoObject.)
Explicit interface implemetationPrivate methodIAlienObject.ResolveGets the instance that contains the information about the object from the Unified Resource Name (URN) of the object. (Inherited from SqlSmoObject.)
Explicit interface implemetationPrivate methodIAlienObject.SetObjectStateSets the object state to the specified SfcObjectState value. (Inherited from SqlSmoObject.)
Explicit interface implemetationPrivate methodIAlienObject.SetPropertyValueSets the property value. (Inherited from SqlSmoObject.)
Explicit interface implemetationPrivate methodISfcPropertyProvider.GetPropertySetGets the interface reference to the set of properties of this object. (Inherited from SqlSmoObject.)
Explicit interface implemetationPrivate propertyISfcSupportsDesignMode.IsDesignModeGets a Boolean value that specifies whether the trigger supports design mode.
Top

To get Trigger object properties, users can be a member of the public fixed server role.

To set Trigger object properties, users must have ALTER permission on the parent table or view.

To create or drop a trigger, users must have ALTER permission on the parent table or view.

To grant, deny, or revoke permission on the trigger to other users, users must have CONTROL permission on the trigger.

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are safe for multithreaded operations. Any instance members are not guaranteed to be thread safe.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft