Microsoft.Data.SqlClient.Server.TriggerAction
The TriggerAction enumeration is used by the SqlTriggerContext class to indicate what action fired the trigger.
namespace Microsoft.Data.SqlClient.Server
{
public enum TriggerAction
{
Invalid = 0,
Insert = 1,
Update = 2,
Delete = 3,
CreateTable = 21,
AlterTable = 22,
DropTable = 23,
CreateIndex = 24,
AlterIndex = 25,
DropIndex = 26,
CreateSecurityExpression = 31,
DropSecurityExpression = 33,
CreateSynonym = 34,
DropSynonym = 36,
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
}
}