TriggerAction 枚举

定义

TriggerAction 枚举由 SqlTriggerContext 类用来指示激发该触发器的操作。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
继承
TriggerAction

字段

AlterAppRole 138

已执行 ALTER APPLICATION ROLE Transact-SQL 语句。An ALTER APPLICATION ROLE Transact-SQL statement was executed.

AlterAssembly 102

已执行 ALTER ASSEMBLY Transact-SQL 语句。An ALTER ASSEMBLY Transact-SQL statement was executed.

AlterBinding 175

当事件通知在数据库或服务器实例上创建时,会指定 ALTER_REMOTE_SERVICE_BINDING 事件类型。An ALTER_REMOTE_SERVICE_BINDING event type was specified when an event notification was created on the database or server instance.

AlterFunction 62

已执行 ALTER FUNCTION Transact-SQL 语句。An ALTER FUNCTION Transact-SQL statement was executed.

AlterIndex 25

已执行 ALTER INDEX Transact-SQL 语句。An ALTER INDEX Transact-SQL statement was executed.

AlterLogin 145

已执行 ALTER LOGIN Transact-SQL 语句。An ALTER LOGIN Transact-SQL statement was executed.

AlterPartitionFunction 192

已执行 ALTER PARTITION FUNCTION Transact-SQL 语句。An ALTER PARTITION FUNCTION Transact-SQL statement was executed.

AlterPartitionScheme 195

已执行 ALTER PARTITION SCHEME Transact-SQL 语句。An ALTER PARTITION SCHEME Transact-SQL statement was executed.

AlterProcedure 52

已执行 ALTER PROCEDURE Transact-SQL 语句。An ALTER PROCEDURE Transact-SQL statement was executed.

AlterQueue 158

已执行 ALTER QUEUE Transact-SQL 语句。An ALTER QUEUE Transact-SQL statement was executed.

AlterRole 135

已执行 ALTER ROLE Transact-SQL 语句。An ALTER ROLE Transact-SQL statement was executed.

AlterRoute 165

已执行 ALTER ROUTE Transact-SQL 语句。An ALTER ROUTE Transact-SQL statement was executed.

AlterSchema 142

已执行 ALTER SCHEMA Transact-SQL 语句。An ALTER SCHEMA Transact-SQL statement was executed.

AlterService 162

已执行 ALTER SERVICE Transact-SQL 语句。An ALTER SERVICE Transact-SQL statement was executed.

AlterTable 22

已执行 ALTER TABLE Transact-SQL 语句。An ALTER TABLE Transact-SQL statement was executed.

AlterTrigger 72

已执行 ALTER TRIGGER Transact-SQL 语句。An ALTER TRIGGER Transact-SQL statement was executed.

AlterUser 132

已执行 ALTER USER Transact-SQL 语句。An ALTER USER Transact-SQL statement was executed.

AlterView 42

已执行 ALTER VIEW Transact-SQL 语句。An ALTER VIEW Transact-SQL statement was executed.

CreateAppRole 137

已执行 CREATE APPLICATION ROLE Transact-SQL 语句。A CREATE APPLICATION ROLE Transact-SQL statement was executed.

CreateAssembly 101

已执行 CREATE ASSEMBLY Transact-SQL 语句。A CREATE ASSEMBLY Transact-SQL statement was executed.

CreateBinding 174

当事件通知在数据库或服务器实例上创建时,会指定 CREATE_REMOTE_SERVICE_BINDING 事件类型。A CREATE_REMOTE_SERVICE_BINDING event type was specified when an event notification was created on the database or server instance.

CreateContract 154

已执行 CREATE CONTRACT Transact-SQL 语句。A CREATE CONTRACT Transact-SQL statement was executed.

CreateEventNotification 74

已执行 CREATE EVENT NOTIFICATION Transact-SQL 语句。A CREATE EVENT NOTIFICATION Transact-SQL statement was executed.

CreateFunction 61

已执行 CREATE FUNCTION Transact-SQL 语句。A CREATE FUNCTION Transact-SQL statement was executed.

CreateIndex 24

已执行 CREATE INDEX Transact-SQL 语句。A CREATE INDEX Transact-SQL statement was executed.

CreateLogin 144

已执行 CREATE LOGIN Transact-SQL 语句。A CREATE LOGIN Transact-SQL statement was executed.

CreateMsgType 151

已执行 CREATE MESSAGE TYPE Transact-SQL 语句。A CREATE MESSAGE TYPE Transact-SQL statement was executed.

CreatePartitionFunction 191

已执行 CREATE PARTITION FUNCTION Transact-SQL 语句。A CREATE PARTITION FUNCTION Transact-SQL statement was executed.

CreatePartitionScheme 194

已执行 CREATE PARTITION SCHEME Transact-SQL 语句。A CREATE PARTITION SCHEME Transact-SQL statement was executed.

CreateProcedure 51

已执行 CREATE PROCEDURE Transact-SQL 语句。A CREATE PROCEDURE Transact-SQL statement was executed.

CreateQueue 157

已执行 CREATE QUEUE Transact-SQL 语句。A CREATE QUEUE Transact-SQL statement was executed.

CreateRole 134

已执行 CREATE ROLE Transact-SQL 语句。A CREATE ROLE Transact-SQL statement was executed.

CreateRoute 164

已执行 CREATE ROUTE Transact-SQL 语句。A CREATE ROUTE Transact-SQL statement was executed.

CreateSchema 141

已执行 CREATE SCHEMA Transact-SQL 语句。A CREATE SCHEMA Transact-SQL statement was executed.

CreateSecurityExpression 31

不可用。Not available.

CreateService 161

已执行 CREATE SERVICE Transact-SQL 语句。A CREATE SERVICE Transact-SQL statement was executed.

CreateSynonym 34

已执行 CREATE SYNONYM Transact-SQL 语句。A CREATE SYNONYM Transact-SQL statement was executed.

CreateTable 21

已执行 CREATE TABLE Transact-SQL 语句。A CREATE TABLE Transact-SQL statement was executed.

CreateTrigger 71

已执行 CREATE TRIGGER Transact-SQL 语句。A CREATE TRIGGER Transact-SQL statement was executed.

CreateType 91

已执行 CREATE TYPE Transact-SQL 语句。A CREATE TYPE Transact-SQL statement was executed.

CreateUser 131

已执行 CREATE USER Transact-SQL 语句。A CREATE USER Transact-SQL statement was executed.

CreateView 41

已执行 CREATE VIEW Transact-SQL 语句。A CREATE VIEW Transact-SQL statement was executed.

Delete 3

已执行 DELETE Transact-SQL 语句。A DELETE Transact-SQL statement was executed.

DenyObject 171

已执行 DENY Object Permissions Transact-SQL 语句。A DENY Object Permissions Transact-SQL statement was executed.

DenyStatement 168

已执行 DENY Transact-SQL 语句。A DENY Transact-SQL statement was executed.

DropAppRole 139

已执行 DROP APPLICATION ROLE Transact-SQL 语句。A DROP APPLICATION ROLE Transact-SQL statement was executed.

DropAssembly 103

已执行 DROP ASSEMBLY Transact-SQL 语句。A DROP ASSEMBLY Transact-SQL statement was executed.

DropBinding 176

当事件通知在数据库或服务器实例上创建时,会指定 DROP_REMOTE_SERVICE_BINDING 事件类型。A DROP_REMOTE_SERVICE_BINDING event type was specified when an event notification was created on the database or server instance.

DropContract 156

已执行 DROP CONTRACT Transact-SQL 语句。A DROP CONTRACT Transact-SQL statement was executed.

DropEventNotification 76

已执行 DROP EVENT NOTIFICATION Transact-SQL 语句。A DROP EVENT NOTIFICATION Transact-SQL statement was executed.

DropFunction 63

已执行 DROP FUNCTION Transact-SQL 语句。A DROP FUNCTION Transact-SQL statement was executed.

DropIndex 26

已执行 DROP INDEX Transact-SQL 语句。A DROP INDEX Transact-SQL statement was executed.

DropLogin 146

已执行 DROP LOGIN Transact-SQL 语句。A DROP LOGIN Transact-SQL statement was executed.

DropMsgType 153

已执行 DROP MESSAGE TYPE Transact-SQL 语句。A DROP MESSAGE TYPE Transact-SQL statement was executed.

DropPartitionFunction 193

已执行 DROP PARTITION FUNCTION Transact-SQL 语句。A DROP PARTITION FUNCTION Transact-SQL statement was executed.

DropPartitionScheme 196

已执行 DROP PARTITION SCHEME Transact-SQL 语句。A DROP PARTITION SCHEME Transact-SQL statement was executed.

DropProcedure 53

已执行 DROP PROCEDURE Transact-SQL 语句。A DROP PROCEDURE Transact-SQL statement was executed.

DropQueue 159

已执行 DROP QUEUE Transact-SQL 语句。A DROP QUEUE Transact-SQL statement was executed.

DropRole 136

已执行 DROP ROLE Transact-SQL 语句。A DROP ROLE Transact-SQL statement was executed.

DropRoute 166

已执行 DROP ROUTE Transact-SQL 语句。A DROP ROUTE Transact-SQL statement was executed.

DropSchema 143

已执行 DROP SCHEMA Transact-SQL 语句。A DROP SCHEMA Transact-SQL statement was executed.

DropSecurityExpression 33

不可用。Not available.

DropService 163

已执行 DROP SERVICE Transact-SQL 语句。A DROP SERVICE Transact-SQL statement was executed.

DropSynonym 36

已执行 DROP SYNONYM Transact-SQL 语句。A DROP SYNONYM Transact-SQL statement was executed.

DropTable 23

已执行 DROP TABLE Transact-SQL 语句。A DROP TABLE Transact-SQL statement was executed.

DropTrigger 73

已执行 DROP TRIGGER Transact-SQL 语句。A DROP TRIGGER Transact-SQL statement was executed.

DropType 93

已执行 DROP TYPE Transact-SQL 语句。A DROP TYPE Transact-SQL statement was executed.

DropUser 133

已执行 DROP USER Transact-SQL 语句。A DROP USER Transact-SQL statement was executed.

DropView 43

已执行 DROP VIEW Transact-SQL 语句。A DROP VIEW Transact-SQL statement was executed.

GrantObject 170

已执行 GRANT OBJECT Transact-SQL 语句。A GRANT OBJECT Transact-SQL statement was executed.

GrantStatement 167

已执行 GRANT Transact-SQL 语句。A GRANT Transact-SQL statement was executed.

Insert 1

已执行 INSERT Transact-SQL 语句。An INSERT Transact-SQL statement was executed.

Invalid 0

出现一个无效触发操作,该操作不向用户公开。An invalid trigger action, one that is not exposed to the user, occurred.

RevokeObject 172

已执行 REVOKE OBJECT Transact-SQL 语句。A REVOKE OBJECT Transact-SQL statement was executed.

RevokeStatement 169

已执行 REVOKE Transact-SQL 语句。A REVOKE Transact-SQL statement was executed.

Update 2

已执行 UPDATE Transact-SQL 语句。An UPDATE Transact-SQL statement was executed.

注解

TriggerAction 枚举由 SqlTriggerContext 类用来指示激发该触发器的操作。The TriggerAction enumeration is used by the SqlTriggerContext class to indicate what action fired the trigger.

有关详细信息, 请参阅Transact-sql 参考For more information, see the Transact-SQL Reference.

适用于