TriggerAction Enumeration

 
System_CAPS_noteNote

The .NET API Reference documentation has a new home. Visit the .NET API Browser on docs.microsoft.com to see the new experience.

The TriggerAction enumeration is used by the SqlTriggerContext class to indicate what action fired the trigger.

Namespace:   Microsoft.SqlServer.Server
Assembly:  System.Data (in System.Data.dll)

public enum TriggerAction

Member nameDescription
AlterAppRole

An ALTER APPLICATION ROLE Transact-SQL statement was executed.

AlterAssembly

An ALTER ASSEMBLY Transact-SQL statement was executed.

AlterBinding

An ALTER_REMOTE_SERVICE_BINDING event type was specified when an event notification was created on the database or server instance.

AlterFunction

An ALTER FUNCTION Transact-SQL statement was executed.

AlterIndex

An ALTER INDEX Transact-SQL statement was executed.

AlterLogin

An ALTER LOGIN Transact-SQL statement was executed.

AlterPartitionFunction

An ALTER PARTITION FUNCTION Transact-SQL statement was executed.

AlterPartitionScheme

An ALTER PARTITION SCHEME Transact-SQL statement was executed.

AlterProcedure

An ALTER PROCEDURE Transact-SQL statement was executed.

AlterQueue

An ALTER QUEUE Transact-SQL statement was executed.

AlterRole

An ALTER ROLE Transact-SQL statement was executed.

AlterRoute

An ALTER ROUTE Transact-SQL statement was executed.

AlterSchema

An ALTER SCHEMA Transact-SQL statement was executed.

AlterService

An ALTER SERVICE Transact-SQL statement was executed.

AlterTable

An ALTER TABLE Transact-SQL statement was executed.

AlterTrigger

An ALTER TRIGGER Transact-SQL statement was executed.

AlterUser

An ALTER USER Transact-SQL statement was executed.

AlterView

An ALTER VIEW Transact-SQL statement was executed.

CreateAppRole

A CREATE APPLICATION ROLE Transact-SQL statement was executed.

CreateAssembly

A CREATE ASSEMBLY Transact-SQL statement was executed.

CreateBinding

A CREATE_REMOTE_SERVICE_BINDING event type was specified when an event notification was created on the database or server instance.

CreateContract

A CREATE CONTRACT Transact-SQL statement was executed.

CreateEventNotification

A CREATE EVENT NOTIFICATION Transact-SQL statement was executed.

CreateFunction

A CREATE FUNCTION Transact-SQL statement was executed.

CreateIndex

A CREATE INDEX Transact-SQL statement was executed.

CreateLogin

A CREATE LOGIN Transact-SQL statement was executed.

CreateMsgType

A CREATE MESSAGE TYPE Transact-SQL statement was executed.

CreatePartitionFunction

A CREATE PARTITION FUNCTION Transact-SQL statement was executed.

CreatePartitionScheme

A CREATE PARTITION SCHEME Transact-SQL statement was executed.

CreateProcedure

A CREATE PROCEDURE Transact-SQL statement was executed.

CreateQueue

A CREATE QUEUE Transact-SQL statement was executed.

CreateRole

A CREATE ROLE Transact-SQL statement was executed.

CreateRoute

A CREATE ROUTE Transact-SQL statement was executed.

CreateSchema

A CREATE SCHEMA Transact-SQL statement was executed.

CreateSecurityExpression

Not available.

CreateService

A CREATE SERVICE Transact-SQL statement was executed.

CreateSynonym

A CREATE SYNONYM Transact-SQL statement was executed.

CreateTable

A CREATE TABLE Transact-SQL statement was executed.

CreateTrigger

A CREATE TRIGGER Transact-SQL statement was executed.

CreateType

A CREATE TYPE Transact-SQL statement was executed.

CreateUser

A CREATE USER Transact-SQL statement was executed.

CreateView

A CREATE VIEW Transact-SQL statement was executed.

Delete

A DELETE Transact-SQL statement was executed.

DenyObject

A DENY Object Permissions Transact-SQL statement was executed.

DenyStatement

A DENY Transact-SQL statement was executed.

DropAppRole

A DROP APPLICATION ROLE Transact-SQL statement was executed.

DropAssembly

A DROP ASSEMBLY Transact-SQL statement was executed.

DropBinding

A DROP_REMOTE_SERVICE_BINDING event type was specified when an event notification was created on the database or server instance.

DropContract

A DROP CONTRACT Transact-SQL statement was executed.

DropEventNotification

A DROP EVENT NOTIFICATION Transact-SQL statement was executed.

DropFunction

A DROP FUNCTION Transact-SQL statement was executed.

DropIndex

A DROP INDEX Transact-SQL statement was executed.

DropLogin

A DROP LOGIN Transact-SQL statement was executed.

DropMsgType

A DROP MESSAGE TYPE Transact-SQL statement was executed.

DropPartitionFunction

A DROP PARTITION FUNCTION Transact-SQL statement was executed.

DropPartitionScheme

A DROP PARTITION SCHEME Transact-SQL statement was executed.

DropProcedure

A DROP PROCEDURE Transact-SQL statement was executed.

DropQueue

A DROP QUEUE Transact-SQL statement was executed.

DropRole

A DROP ROLE Transact-SQL statement was executed.

DropRoute

A DROP ROUTE Transact-SQL statement was executed.

DropSchema

A DROP SCHEMA Transact-SQL statement was executed.

DropSecurityExpression

Not available.

DropService

A DROP SERVICE Transact-SQL statement was executed.

DropSynonym

A DROP SYNONYM Transact-SQL statement was executed.

DropTable

A DROP TABLE Transact-SQL statement was executed.

DropTrigger

A DROP TRIGGER Transact-SQL statement was executed.

DropType

A DROP TYPE Transact-SQL statement was executed.

DropUser

A DROP USER Transact-SQL statement was executed.

DropView

A DROP VIEW Transact-SQL statement was executed.

GrantObject

A GRANT OBJECT Transact-SQL statement was executed.

GrantStatement

A GRANT Transact-SQL statement was executed.

Insert

An INSERT Transact-SQL statement was executed.

Invalid

An invalid trigger action, one that is not exposed to the user, occurred.

RevokeObject

A REVOKE OBJECT Transact-SQL statement was executed.

RevokeStatement

A REVOKE Transact-SQL statement was executed.

Update

An UPDATE Transact-SQL statement was executed.

The TriggerAction enumeration is used by the SqlTriggerContext class to indicate what action fired the trigger.

For more information, see the Transact-SQL Reference of SQL Server Books Online.

.NET Framework
Available since 2.0
Return to top
Show: