TriggerAction Enumeration
The TriggerAction enumeration is used by the SqlTriggerContext class to indicate what action fired the trigger.
Assembly: System.Data (in System.Data.dll)
| Member name | Description | |
|---|---|---|
| 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.
Available since 2.0