TriggerAction

Microsoft.SqlServer.Server.TriggerAction, System.Data underlying int32 System.Data

Values 76

Name	Value	Hex
Invalid		0x00
Insert		0x01
Update		0x02
Delete		0x03
CreateTable		0x15
AlterTable		0x16
DropTable		0x17
CreateIndex		0x18
AlterIndex		0x19
DropIndex		0x1A
CreateSynonym		0x22
DropSynonym		0x24
CreateSecurityExpression		0x1F
DropSecurityExpression		0x21
CreateView		0x29
AlterView		0x2A
DropView		0x2B
CreateProcedure		0x33
AlterProcedure		0x34
DropProcedure		0x35
CreateFunction		0x3D
AlterFunction		0x3E
DropFunction		0x3F
CreateTrigger		0x47
AlterTrigger		0x48
DropTrigger		0x49
CreateEventNotification		0x4A
DropEventNotification		0x4C
CreateType		0x5B
DropType		0x5D
CreateAssembly		0x65
AlterAssembly		0x66
DropAssembly		0x67
CreateUser		0x83
AlterUser		0x84
DropUser		0x85
CreateRole		0x86
AlterRole		0x87
DropRole		0x88
CreateAppRole		0x89
AlterAppRole		0x8A
DropAppRole		0x8B
CreateSchema		0x8D
AlterSchema		0x8E
DropSchema		0x8F
CreateLogin		0x90
AlterLogin		0x91
DropLogin		0x92
CreateMsgType		0x97
DropMsgType		0x99
CreateContract		0x9A
DropContract		0x9C
CreateQueue		0x9D
AlterQueue		0x9E
DropQueue		0x9F
CreateService		0xA1
AlterService		0xA2
DropService		0xA3
CreateRoute		0xA4
AlterRoute		0xA5
DropRoute		0xA6
GrantStatement		0xA7
DenyStatement		0xA8
RevokeStatement		0xA9
GrantObject		0xAA
DenyObject		0xAB
RevokeObject		0xAC
CreateBinding		0xAE
AlterBinding		0xAF
DropBinding		0xB0
CreatePartitionFunction		0xBF
AlterPartitionFunction		0xC0
DropPartitionFunction		0xC1
CreatePartitionScheme		0xC2
AlterPartitionScheme		0xC3
DropPartitionScheme		0xC4

// Microsoft.SqlServer.Server.TriggerAction, System.Data
enum class TriggerAction : int32
{
    Invalid = 0,
    Insert = 1,
    Update = 2,
    Delete = 3,
    CreateTable = 21,
    AlterTable = 22,
    DropTable = 23,
    CreateIndex = 24,
    AlterIndex = 25,
    DropIndex = 26,
    CreateSynonym = 34,
    DropSynonym = 36,
    CreateSecurityExpression = 31,
    DropSecurityExpression = 33,
    CreateView = 41,
    AlterView = 42,
    DropView = 43,
    CreateProcedure = 51,
    AlterProcedure = 52,
    DropProcedure = 53,
    CreateFunction = 61,
    AlterFunction = 62,
    DropFunction = 63,
    CreateTrigger = 71,
    AlterTrigger = 72,
    DropTrigger = 73,
    CreateEventNotification = 74,
    DropEventNotification = 76,
    CreateType = 91,
    DropType = 93,
    CreateAssembly = 101,
    AlterAssembly = 102,
    DropAssembly = 103,
    CreateUser = 131,
    AlterUser = 132,
    DropUser = 133,
    CreateRole = 134,
    AlterRole = 135,
    DropRole = 136,
    CreateAppRole = 137,
    AlterAppRole = 138,
    DropAppRole = 139,
    CreateSchema = 141,
    AlterSchema = 142,
    DropSchema = 143,
    CreateLogin = 144,
    AlterLogin = 145,
    DropLogin = 146,
    CreateMsgType = 151,
    DropMsgType = 153,
    CreateContract = 154,
    DropContract = 156,
    CreateQueue = 157,
    AlterQueue = 158,
    DropQueue = 159,
    CreateService = 161,
    AlterService = 162,
    DropService = 163,
    CreateRoute = 164,
    AlterRoute = 165,
    DropRoute = 166,
    GrantStatement = 167,
    DenyStatement = 168,
    RevokeStatement = 169,
    GrantObject = 170,
    DenyObject = 171,
    RevokeObject = 172,
    CreateBinding = 174,
    AlterBinding = 175,
    DropBinding = 176,
    CreatePartitionFunction = 191,
    AlterPartitionFunction = 192,
    DropPartitionFunction = 193,
    CreatePartitionScheme = 194,
    AlterPartitionScheme = 195,
    DropPartitionScheme = 196,
};