TriggerAction Enumeration

TriggerAction Enumeration

 

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:
© 2016 Microsoft