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 | |
|---|---|---|
| Invalid | An invalid trigger action, one that is not exposed to the user, occurred. | |
| Insert | An INSERT Transact-SQL statement was executed. | |
| Update | An UPDATE Transact-SQL statement was executed. | |
| Delete | A DELETE Transact-SQL statement was executed. | |
| CreateTable | A CREATE TABLE Transact-SQL statement was executed. | |
| AlterTable | An ALTER TABLE Transact-SQL statement was executed. | |
| DropTable | A DROP TABLE Transact-SQL statement was executed. | |
| CreateIndex | A CREATE INDEX Transact-SQL statement was executed. | |
| AlterIndex | An ALTER INDEX Transact-SQL statement was executed. | |
| DropIndex | A DROP INDEX Transact-SQL statement was executed. | |
| CreateSynonym | A CREATE SYNONYM Transact-SQL statement was executed. | |
| DropSynonym | A DROP SYNONYM Transact-SQL statement was executed. | |
| CreateSecurityExpression | Not available. | |
| DropSecurityExpression | Not available. | |
| CreateView | A CREATE VIEW Transact-SQL statement was executed. | |
| AlterView | An ALTER VIEW Transact-SQL statement was executed. | |
| DropView | A DROP VIEW Transact-SQL statement was executed. | |
| CreateProcedure | A CREATE PROCEDURE Transact-SQL statement was executed. | |
| AlterProcedure | An ALTER PROCEDURE Transact-SQL statement was executed. | |
| DropProcedure | A DROP PROCEDURE Transact-SQL statement was executed. | |
| CreateFunction | A CREATE FUNCTION Transact-SQL statement was executed. | |
| AlterFunction | An ALTER FUNCTION Transact-SQL statement was executed. | |
| DropFunction | A DROP FUNCTION Transact-SQL statement was executed. | |
| CreateTrigger | A CREATE TRIGGER Transact-SQL statement was executed. | |
| AlterTrigger | An ALTER TRIGGER Transact-SQL statement was executed. | |
| DropTrigger | A DROP TRIGGER Transact-SQL statement was executed. | |
| CreateEventNotification | A CREATE EVENT NOTIFICATION Transact-SQL statement was executed. | |
| DropEventNotification | A DROP EVENT NOTIFICATION Transact-SQL statement was executed. | |
| CreateType | A CREATE TYPE Transact-SQL statement was executed. | |
| DropType | A DROP TYPE Transact-SQL statement was executed. | |
| CreateAssembly | A CREATE ASSEMBLY Transact-SQL statement was executed. | |
| AlterAssembly | An ALTER ASSEMBLY Transact-SQL statement was executed. | |
| DropAssembly | A DROP ASSEMBLY Transact-SQL statement was executed. | |
| CreateUser | A CREATE USER Transact-SQL statement was executed. | |
| AlterUser | An ALTER USER Transact-SQL statement was executed. | |
| DropUser | A DROP USER Transact-SQL statement was executed. | |
| CreateRole | A CREATE ROLE Transact-SQL statement was executed. | |
| AlterRole | An ALTER ROLE Transact-SQL statement was executed. | |
| DropRole | A DROP ROLE Transact-SQL statement was executed. | |
| CreateAppRole | A CREATE APPLICATION ROLE Transact-SQL statement was executed. | |
| AlterAppRole | An ALTER APPLICATION ROLE Transact-SQL statement was executed. | |
| DropAppRole | A DROP APPLICATION ROLE Transact-SQL statement was executed. | |
| CreateSchema | A CREATE SCHEMA Transact-SQL statement was executed. | |
| AlterSchema | An ALTER SCHEMA Transact-SQL statement was executed. | |
| DropSchema | A DROP SCHEMA Transact-SQL statement was executed. | |
| CreateLogin | A CREATE LOGIN Transact-SQL statement was executed. | |
| AlterLogin | An ALTER LOGIN Transact-SQL statement was executed. | |
| DropLogin | A DROP LOGIN Transact-SQL statement was executed. | |
| CreateMsgType | A CREATE MESSAGE TYPE Transact-SQL statement was executed. | |
| DropMsgType | A DROP MESSAGE TYPE Transact-SQL statement was executed. | |
| CreateContract | A CREATE CONTRACT Transact-SQL statement was executed. | |
| DropContract | A DROP CONTRACT Transact-SQL statement was executed. | |
| CreateQueue | A CREATE QUEUE Transact-SQL statement was executed. | |
| AlterQueue | An ALTER QUEUE Transact-SQL statement was executed. | |
| DropQueue | A DROP QUEUE Transact-SQL statement was executed. | |
| CreateService | A CREATE SERVICE Transact-SQL statement was executed. | |
| AlterService | An ALTER SERVICE Transact-SQL statement was executed. | |
| DropService | A DROP SERVICE Transact-SQL statement was executed. | |
| CreateRoute | A CREATE ROUTE Transact-SQL statement was executed. | |
| AlterRoute | An ALTER ROUTE Transact-SQL statement was executed. | |
| DropRoute | A DROP ROUTE Transact-SQL statement was executed. | |
| GrantStatement | A GRANT Transact-SQL statement was executed. | |
| DenyStatement | A DENY Transact-SQL statement was executed. | |
| RevokeStatement | A REVOKE Transact-SQL statement was executed. | |
| GrantObject | A GRANT OBJECT Transact-SQL statement was executed. | |
| DenyObject | A DENY Object Permissions Transact-SQL statement was executed. | |
| RevokeObject | A REVOKE OBJECT 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. | |
| AlterBinding | An ALTER_REMOTE_SERVICE_BINDING event type was specified when an event notification was created on the database or server instance. | |
| DropBinding | A DROP_REMOTE_SERVICE_BINDING event type was specified when an event notification was created on the database or server instance. | |
| CreatePartitionFunction | A CREATE PARTITION FUNCTION Transact-SQL statement was executed. | |
| AlterPartitionFunction | An ALTER PARTITION FUNCTION Transact-SQL statement was executed. | |
| DropPartitionFunction | A DROP PARTITION FUNCTION Transact-SQL statement was executed. | |
| CreatePartitionScheme | A CREATE PARTITION SCHEME Transact-SQL statement was executed. | |
| AlterPartitionScheme | An ALTER PARTITION SCHEME Transact-SQL statement was executed. | |
| DropPartitionScheme | A DROP PARTITION SCHEME 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.
Windows 7, Windows Vista, Windows XP SP2, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP Starter Edition, Windows Server 2008 R2, Windows Server 2008, Windows Server 2003, Windows Server 2000 SP4, Windows Millennium Edition, Windows 98
The .NET Framework and .NET Compact Framework do not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.