Export (0) Print
Expand All

Trigger Class

 

Applies To: SQL Server 2016 Preview

The Trigger object represents a SQL Server trigger.

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


[PhysicalFacetAttribute(PhysicalFacetOptions::ReadOnly)]
[EvaluationModeAttribute(AutomatedPolicyEvaluationMode::CheckOnSchedule)]
public ref class Trigger sealed : ScriptNameObjectBase, ISfcSupportsDesignMode, 
	ICreatable, IAlterable, IDroppable, IMarkForDrop, IExtendedProperties, 
	IScriptable, ITextObject

NameDescription
System_CAPS_pubmethodTrigger()

Initializes a new instance of the Trigger class.

System_CAPS_pubmethodTrigger(SqlSmoObject^, String^)

Initializes a new instance of the Trigger class on the specified object, and with the specified name.

NameDescription
System_CAPS_pubpropertyAnsiNullsStatus

Gets the Boolean property value that specifies whether ISO NULL handling is enabled in the trigger.

System_CAPS_pubpropertyAssemblyName

Gets or sets the name of the .NET assembly that is required by the referenced trigger.

System_CAPS_pubpropertyClassName

Gets or sets the name of the class that is called by the referenced trigger.

System_CAPS_pubpropertyCreateDate

Gets the date and time when the trigger was created.

System_CAPS_pubpropertyDateLastModified

Gets the date and time when the trigger was last modified.

System_CAPS_pubpropertyDelete

Gets or sets the Boolean property value that specifies whether the trigger is executed when records are deleted from the table.

System_CAPS_pubpropertyDeleteOrder

Gets or sets the order in which the trigger and the delete operation are executed.

System_CAPS_pubpropertyEvents

Gets the events that are associated with the trigger.

System_CAPS_pubpropertyExecutionContext

Gets or sets the execution context.

System_CAPS_pubpropertyExecutionContextPrincipal

Gets or sets the execution context principal.

System_CAPS_pubpropertyExtendedProperties

Gets the extended properties of the Trigger object.

System_CAPS_pubpropertyID

Gets the ID value that uniquely identifies the trigger.

System_CAPS_pubpropertyImplementationType

Gets or sets the implementation type of the trigger.

System_CAPS_pubpropertyInsert

Gets or sets the Boolean property value that specifies whether the trigger is fired when records are inserted into the table.

System_CAPS_pubpropertyInsertOrder

Gets or sets the order in which the trigger and the insert operation are executed.

System_CAPS_pubpropertyInsteadOf

Gets or sets a Boolean property that specifies whether the trigger runs instead of the insert, delete, or update operation.

System_CAPS_pubpropertyIsEnabled

Gets or sets the Boolean property that specifies whether the trigger is enabled.

System_CAPS_pubpropertyIsEncrypted

Gets or sets the Boolean property value that specifies whether the trigger is encrypted.

System_CAPS_pubpropertyIsSystemObject

Gets the Boolean property value that specifies whether the trigger is a system object.

System_CAPS_pubpropertyMethodName

Gets the method name for the trigger.

System_CAPS_pubpropertyName

Gets or sets a String value that specifies the name of the trigger.(Overrides NamedSmoObject::Name.)

System_CAPS_pubpropertyNotForReplication

Gets or sets a Boolean property value that specifies whether the trigger is included in replication operations.

System_CAPS_pubpropertyParent

Gets or sets the SqlSmoObject object that is the parent of the Trigger object.

System_CAPS_pubpropertyProperties

Gets a collection of Property objects that represent the object properties.(Inherited from SqlSmoObject.)

System_CAPS_pubpropertyQuotedIdentifierStatus

Gets 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.

System_CAPS_pubpropertyState

Gets the state of the referenced object.(Inherited from SmoObjectBase.)

System_CAPS_pubpropertyTextBody

Gets or sets the Transact-SQL string that defines the trigger.

System_CAPS_pubpropertyTextHeader

Gets or sets the header part of the Transact-SQL string that defines the trigger.

System_CAPS_pubpropertyTextMode

Gets or sets the Boolean property that specifies whether the text header is editable as text.

System_CAPS_pubpropertyUpdate

Gets or sets the Boolean property value that specifies whether the trigger is fired when records are updated in the table.

System_CAPS_pubpropertyUpdateOrder

Gets or sets the order in which the trigger and the update operation are executed.

System_CAPS_pubpropertyUrn

Gets the Uniform Resource Name (URN) address value that uniquely identifies the object.(Inherited from SqlSmoObject.)

System_CAPS_pubpropertyUserData

Gets or sets user-defined data associated with the referenced object.(Inherited from SmoObjectBase.)

NameDescription
System_CAPS_pubmethodAlter()

Updates any Trigger object property changes on instance of Microsoft SQL Server . 

System_CAPS_pubmethodCreate()

Creates a trigger on the instance of SQL Server as defined by the Trigger object.

System_CAPS_pubmethodDiscover()

Discovers a list of type Object.(Inherited from SqlSmoObject.)

System_CAPS_pubmethodDrop()

Removes the trigger from the instance of SQL Server .

System_CAPS_pubmethodEquals(Object^)

(Inherited from Object.)

System_CAPS_protmethodFormatSqlVariant(Object^)

Formats an object as T: Microsoft.Data.Schema.Sql.DataGenerator.SqlVariant type.(Inherited from SqlSmoObject.)

System_CAPS_protmethodGetContextDB()

Gets the context database that is associated with this object.(Inherited from SqlSmoObject.)

System_CAPS_protmethodGetDBName()

Gets the database name that is associated with the object.(Inherited from SqlSmoObject.)

System_CAPS_pubmethodGetHashCode()

(Inherited from Object.)

System_CAPS_protmethodGetPropValue(String^)

Gets a property value of the SqlSmoObject object.(Inherited from SqlSmoObject.)

System_CAPS_protmethodGetPropValueOptional(String^)

Gets a property value of the SqlSmoObject object.(Inherited from SqlSmoObject.)

System_CAPS_protmethodGetPropValueOptionalAllowNull(String^)

Gets a property value of the SqlSmoObject object.(Inherited from SqlSmoObject.)

System_CAPS_protmethodGetServerObject()

Gets the server of the SqlSmoObject object.(Inherited from SqlSmoObject.)

System_CAPS_pubmethodGetType()

(Inherited from Object.)

System_CAPS_pubmethodInitialize()

Initializes the object and forces the properties be loaded.(Inherited from SqlSmoObject.)

System_CAPS_pubmethodInitialize(Boolean)

Initializes the object and forces the properties be loaded.(Inherited from SqlSmoObject.)

System_CAPS_protmethodIsObjectInitialized()

Verifies whether the object has been initialized.(Inherited from SqlSmoObject.)

System_CAPS_protmethodIsObjectInSpace()

Verifies whether the object is isolated or connected to the instance of SQL Server.(Inherited from SqlSmoObject.)

System_CAPS_pubmethodMarkForDrop(Boolean)

Marks the trigger to be dropped.

System_CAPS_pubmethodReCompileReferences()

Recompiles any stored procedure or trigger that depends on the base SMO object.

System_CAPS_pubmethodRefresh()

Refreshes the script name.(Inherited from ScriptNameObjectBase.)

System_CAPS_pubmethodScript()

Generates a Transact-SQL script that can be used to re-create the trigger.

System_CAPS_pubmethodScript(ScriptingOptions^)

Generates a Transact-SQL script that can be used to re-create the trigger as specified by the script options.

System_CAPS_pubmethodScriptHeader(Boolean)

Returns the text header with the option to modify the text.

System_CAPS_protmethodSetParentImpl(SqlSmoObject^)

Sets the parent of the SqlSmoObject to the newParent parameter.(Inherited from SqlSmoObject.)

System_CAPS_pubmethodToString()

Returns a String that represents the referenced object.(Inherited from SqlSmoObject.)

System_CAPS_pubmethodValidate(String^, array<Object^>^)

Validates the state of an object.(Inherited from SmoObjectBase.)

NameDescription
System_CAPS_pubeventPropertyChanged

Represents the event that occurs when a property is changed.(Inherited from SqlSmoObject.)

System_CAPS_pubeventPropertyMetadataChanged

Represents the event that occurs when property metadata changes.(Inherited from SqlSmoObject.)

NameDescription
System_CAPS_pubinterfaceSystem_CAPS_privmethodIAlienObject::Discover()

Discovers any dependencies.

Do not reference this member directly in your code. It supports the SQL Server infrastructure.(Inherited from SqlSmoObject.)

System_CAPS_pubinterfaceSystem_CAPS_privmethodIAlienObject::GetDomainRoot()

Returns the root of the domain.(Inherited from SqlSmoObject.)

System_CAPS_pubinterfaceSystem_CAPS_privmethodIAlienObject::GetParent()

Gets the parent of this object. Do not reference this member directly in your code. It supports the SQL Server infrastructure.(Inherited from SqlSmoObject.)

System_CAPS_pubinterfaceSystem_CAPS_privmethodIAlienObject::GetPropertyType(String^)

Gets the type of the specified property.(Inherited from SqlSmoObject.)

System_CAPS_pubinterfaceSystem_CAPS_privmethodIAlienObject::GetPropertyValue(String^, Type^)

Gets the value of the specified property.(Inherited from SqlSmoObject.)

System_CAPS_pubinterfaceSystem_CAPS_privmethodIAlienObject::GetUrn()

Gets 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.)

System_CAPS_pubinterfaceSystem_CAPS_privmethodIAlienObject::Resolve(String^)

Gets the instance that contains the information about the object from the Unified Resource Name (URN) of the object.(Inherited from SqlSmoObject.)

System_CAPS_pubinterfaceSystem_CAPS_privmethodIAlienObject::SetObjectState(SfcObjectState)

Sets the object state to the specified SfcObjectState value.(Inherited from SqlSmoObject.)

System_CAPS_pubinterfaceSystem_CAPS_privmethodIAlienObject::SetPropertyValue(String^, Type^, Object^)

Sets the property value.(Inherited from SqlSmoObject.)

System_CAPS_pubinterfaceSystem_CAPS_privmethodISfcPropertyProvider::GetPropertySet()

Gets the interface reference to the set of properties of this object.

Do not reference this member directly in your code. It supports the SQL Server infrastructure.(Inherited from SqlSmoObject.)

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.

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.

Return to top
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

Show:
© 2015 Microsoft