TriggerAction TriggerAction TriggerAction TriggerAction Enum

Definition

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

public enum class TriggerAction
public enum TriggerAction
type TriggerAction = 
Public Enum TriggerAction
Inheritance
TriggerActionTriggerActionTriggerActionTriggerAction

Fields

AlterAppRole AlterAppRole AlterAppRole AlterAppRole 138

An ALTER APPLICATION ROLE Transact-SQL statement was executed.

AlterAssembly AlterAssembly AlterAssembly AlterAssembly 102

An ALTER ASSEMBLY Transact-SQL statement was executed.

AlterBinding AlterBinding AlterBinding AlterBinding 175

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

AlterFunction AlterFunction AlterFunction AlterFunction 62

An ALTER FUNCTION Transact-SQL statement was executed.

AlterIndex AlterIndex AlterIndex AlterIndex 25

An ALTER INDEX Transact-SQL statement was executed.

AlterLogin AlterLogin AlterLogin AlterLogin 145

An ALTER LOGIN Transact-SQL statement was executed.

AlterPartitionFunction AlterPartitionFunction AlterPartitionFunction AlterPartitionFunction 192

An ALTER PARTITION FUNCTION Transact-SQL statement was executed.

AlterPartitionScheme AlterPartitionScheme AlterPartitionScheme AlterPartitionScheme 195

An ALTER PARTITION SCHEME Transact-SQL statement was executed.

AlterProcedure AlterProcedure AlterProcedure AlterProcedure 52

An ALTER PROCEDURE Transact-SQL statement was executed.

AlterQueue AlterQueue AlterQueue AlterQueue 158

An ALTER QUEUE Transact-SQL statement was executed.

AlterRole AlterRole AlterRole AlterRole 135

An ALTER ROLE Transact-SQL statement was executed.

AlterRoute AlterRoute AlterRoute AlterRoute 165

An ALTER ROUTE Transact-SQL statement was executed.

AlterSchema AlterSchema AlterSchema AlterSchema 142

An ALTER SCHEMA Transact-SQL statement was executed.

AlterService AlterService AlterService AlterService 162

An ALTER SERVICE Transact-SQL statement was executed.

AlterTable AlterTable AlterTable AlterTable 22

An ALTER TABLE Transact-SQL statement was executed.

AlterTrigger AlterTrigger AlterTrigger AlterTrigger 72

An ALTER TRIGGER Transact-SQL statement was executed.

AlterUser AlterUser AlterUser AlterUser 132

An ALTER USER Transact-SQL statement was executed.

AlterView AlterView AlterView AlterView 42

An ALTER VIEW Transact-SQL statement was executed.

CreateAppRole CreateAppRole CreateAppRole CreateAppRole 137

A CREATE APPLICATION ROLE Transact-SQL statement was executed.

CreateAssembly CreateAssembly CreateAssembly CreateAssembly 101

A CREATE ASSEMBLY Transact-SQL statement was executed.

CreateBinding CreateBinding CreateBinding CreateBinding 174

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

CreateContract CreateContract CreateContract CreateContract 154

A CREATE CONTRACT Transact-SQL statement was executed.

CreateEventNotification CreateEventNotification CreateEventNotification CreateEventNotification 74

A CREATE EVENT NOTIFICATION Transact-SQL statement was executed.

CreateFunction CreateFunction CreateFunction CreateFunction 61

A CREATE FUNCTION Transact-SQL statement was executed.

CreateIndex CreateIndex CreateIndex CreateIndex 24

A CREATE INDEX Transact-SQL statement was executed.

CreateLogin CreateLogin CreateLogin CreateLogin 144

A CREATE LOGIN Transact-SQL statement was executed.

CreateMsgType CreateMsgType CreateMsgType CreateMsgType 151

A CREATE MESSAGE TYPE Transact-SQL statement was executed.

CreatePartitionFunction CreatePartitionFunction CreatePartitionFunction CreatePartitionFunction 191

A CREATE PARTITION FUNCTION Transact-SQL statement was executed.

CreatePartitionScheme CreatePartitionScheme CreatePartitionScheme CreatePartitionScheme 194

A CREATE PARTITION SCHEME Transact-SQL statement was executed.

CreateProcedure CreateProcedure CreateProcedure CreateProcedure 51

A CREATE PROCEDURE Transact-SQL statement was executed.

CreateQueue CreateQueue CreateQueue CreateQueue 157

A CREATE QUEUE Transact-SQL statement was executed.

CreateRole CreateRole CreateRole CreateRole 134

A CREATE ROLE Transact-SQL statement was executed.

CreateRoute CreateRoute CreateRoute CreateRoute 164

A CREATE ROUTE Transact-SQL statement was executed.

CreateSchema CreateSchema CreateSchema CreateSchema 141

A CREATE SCHEMA Transact-SQL statement was executed.

CreateSecurityExpression CreateSecurityExpression CreateSecurityExpression CreateSecurityExpression 31

Not available.

CreateService CreateService CreateService CreateService 161

A CREATE SERVICE Transact-SQL statement was executed.

CreateSynonym CreateSynonym CreateSynonym CreateSynonym 34

A CREATE SYNONYM Transact-SQL statement was executed.

CreateTable CreateTable CreateTable CreateTable 21

A CREATE TABLE Transact-SQL statement was executed.

CreateTrigger CreateTrigger CreateTrigger CreateTrigger 71

A CREATE TRIGGER Transact-SQL statement was executed.

CreateType CreateType CreateType CreateType 91

A CREATE TYPE Transact-SQL statement was executed.

CreateUser CreateUser CreateUser CreateUser 131

A CREATE USER Transact-SQL statement was executed.

CreateView CreateView CreateView CreateView 41

A CREATE VIEW Transact-SQL statement was executed.

Delete Delete Delete Delete 3

A DELETE Transact-SQL statement was executed.

DenyObject DenyObject DenyObject DenyObject 171

A DENY Object Permissions Transact-SQL statement was executed.

DenyStatement DenyStatement DenyStatement DenyStatement 168

A DENY Transact-SQL statement was executed.

DropAppRole DropAppRole DropAppRole DropAppRole 139

A DROP APPLICATION ROLE Transact-SQL statement was executed.

DropAssembly DropAssembly DropAssembly DropAssembly 103

A DROP ASSEMBLY Transact-SQL statement was executed.

DropBinding DropBinding DropBinding DropBinding 176

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

DropContract DropContract DropContract DropContract 156

A DROP CONTRACT Transact-SQL statement was executed.

DropEventNotification DropEventNotification DropEventNotification DropEventNotification 76

A DROP EVENT NOTIFICATION Transact-SQL statement was executed.

DropFunction DropFunction DropFunction DropFunction 63

A DROP FUNCTION Transact-SQL statement was executed.

DropIndex DropIndex DropIndex DropIndex 26

A DROP INDEX Transact-SQL statement was executed.

DropLogin DropLogin DropLogin DropLogin 146

A DROP LOGIN Transact-SQL statement was executed.

DropMsgType DropMsgType DropMsgType DropMsgType 153

A DROP MESSAGE TYPE Transact-SQL statement was executed.

DropPartitionFunction DropPartitionFunction DropPartitionFunction DropPartitionFunction 193

A DROP PARTITION FUNCTION Transact-SQL statement was executed.

DropPartitionScheme DropPartitionScheme DropPartitionScheme DropPartitionScheme 196

A DROP PARTITION SCHEME Transact-SQL statement was executed.

DropProcedure DropProcedure DropProcedure DropProcedure 53

A DROP PROCEDURE Transact-SQL statement was executed.

DropQueue DropQueue DropQueue DropQueue 159

A DROP QUEUE Transact-SQL statement was executed.

DropRole DropRole DropRole DropRole 136

A DROP ROLE Transact-SQL statement was executed.

DropRoute DropRoute DropRoute DropRoute 166

A DROP ROUTE Transact-SQL statement was executed.

DropSchema DropSchema DropSchema DropSchema 143

A DROP SCHEMA Transact-SQL statement was executed.

DropSecurityExpression DropSecurityExpression DropSecurityExpression DropSecurityExpression 33

Not available.

DropService DropService DropService DropService 163

A DROP SERVICE Transact-SQL statement was executed.

DropSynonym DropSynonym DropSynonym DropSynonym 36

A DROP SYNONYM Transact-SQL statement was executed.

DropTable DropTable DropTable DropTable 23

A DROP TABLE Transact-SQL statement was executed.

DropTrigger DropTrigger DropTrigger DropTrigger 73

A DROP TRIGGER Transact-SQL statement was executed.

DropType DropType DropType DropType 93

A DROP TYPE Transact-SQL statement was executed.

DropUser DropUser DropUser DropUser 133

A DROP USER Transact-SQL statement was executed.

DropView DropView DropView DropView 43

A DROP VIEW Transact-SQL statement was executed.

GrantObject GrantObject GrantObject GrantObject 170

A GRANT OBJECT Transact-SQL statement was executed.

GrantStatement GrantStatement GrantStatement GrantStatement 167

A GRANT Transact-SQL statement was executed.

Insert Insert Insert Insert 1

An INSERT Transact-SQL statement was executed.

Invalid Invalid Invalid Invalid 0

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

RevokeObject RevokeObject RevokeObject RevokeObject 172

A REVOKE OBJECT Transact-SQL statement was executed.

RevokeStatement RevokeStatement RevokeStatement RevokeStatement 169

A REVOKE Transact-SQL statement was executed.

Update Update Update Update 2

An UPDATE Transact-SQL statement was executed.

Remarks

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

For more information, see the Transact-SQL Reference.

Applies to