TriggerAction TriggerAction TriggerAction TriggerAction Enum

定义

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
继承
TriggerActionTriggerActionTriggerActionTriggerAction

字段

AlterAppRole AlterAppRole AlterAppRole AlterAppRole 138

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

AlterAssembly AlterAssembly AlterAssembly AlterAssembly 102

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

AlterBinding AlterBinding AlterBinding 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 AlterFunction AlterFunction AlterFunction 62

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

AlterIndex AlterIndex AlterIndex AlterIndex 25

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

AlterLogin AlterLogin AlterLogin AlterLogin 145

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

AlterPartitionFunction AlterPartitionFunction AlterPartitionFunction AlterPartitionFunction 192

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

AlterPartitionScheme AlterPartitionScheme AlterPartitionScheme AlterPartitionScheme 195

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

AlterProcedure AlterProcedure AlterProcedure AlterProcedure 52

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

AlterQueue AlterQueue AlterQueue AlterQueue 158

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

AlterRole AlterRole AlterRole AlterRole 135

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

AlterRoute AlterRoute AlterRoute AlterRoute 165

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

AlterSchema AlterSchema AlterSchema AlterSchema 142

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

AlterService AlterService AlterService AlterService 162

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

AlterTable AlterTable AlterTable AlterTable 22

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

AlterTrigger AlterTrigger AlterTrigger AlterTrigger 72

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

AlterUser AlterUser AlterUser AlterUser 132

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

AlterView AlterView AlterView AlterView 42

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

CreateAppRole CreateAppRole CreateAppRole CreateAppRole 137

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

CreateAssembly CreateAssembly CreateAssembly CreateAssembly 101

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

CreateBinding CreateBinding CreateBinding 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 CreateContract CreateContract CreateContract 154

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

CreateEventNotification CreateEventNotification CreateEventNotification CreateEventNotification 74

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

CreateFunction CreateFunction CreateFunction CreateFunction 61

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

CreateIndex CreateIndex CreateIndex CreateIndex 24

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

CreateLogin CreateLogin CreateLogin CreateLogin 144

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

CreateMsgType CreateMsgType CreateMsgType CreateMsgType 151

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

CreatePartitionFunction CreatePartitionFunction CreatePartitionFunction CreatePartitionFunction 191

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

CreatePartitionScheme CreatePartitionScheme CreatePartitionScheme CreatePartitionScheme 194

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

CreateProcedure CreateProcedure CreateProcedure CreateProcedure 51

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

CreateQueue CreateQueue CreateQueue CreateQueue 157

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

CreateRole CreateRole CreateRole CreateRole 134

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

CreateRoute CreateRoute CreateRoute CreateRoute 164

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

CreateSchema CreateSchema CreateSchema CreateSchema 141

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

CreateSecurityExpression CreateSecurityExpression CreateSecurityExpression CreateSecurityExpression 31

不可用。Not available.

CreateService CreateService CreateService CreateService 161

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

CreateSynonym CreateSynonym CreateSynonym CreateSynonym 34

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

CreateTable CreateTable CreateTable CreateTable 21

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

CreateTrigger CreateTrigger CreateTrigger CreateTrigger 71

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

CreateType CreateType CreateType CreateType 91

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

CreateUser CreateUser CreateUser CreateUser 131

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

CreateView CreateView CreateView CreateView 41

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

Delete Delete Delete Delete 3

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

DenyObject DenyObject DenyObject DenyObject 171

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

DenyStatement DenyStatement DenyStatement DenyStatement 168

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

DropAppRole DropAppRole DropAppRole DropAppRole 139

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

DropAssembly DropAssembly DropAssembly DropAssembly 103

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

DropBinding DropBinding DropBinding 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 DropContract DropContract DropContract 156

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

DropEventNotification DropEventNotification DropEventNotification DropEventNotification 76

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

DropFunction DropFunction DropFunction DropFunction 63

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

DropIndex DropIndex DropIndex DropIndex 26

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

DropLogin DropLogin DropLogin DropLogin 146

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

DropMsgType DropMsgType DropMsgType DropMsgType 153

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

DropPartitionFunction DropPartitionFunction DropPartitionFunction DropPartitionFunction 193

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

DropPartitionScheme DropPartitionScheme DropPartitionScheme DropPartitionScheme 196

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

DropProcedure DropProcedure DropProcedure DropProcedure 53

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

DropQueue DropQueue DropQueue DropQueue 159

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

DropRole DropRole DropRole DropRole 136

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

DropRoute DropRoute DropRoute DropRoute 166

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

DropSchema DropSchema DropSchema DropSchema 143

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

DropSecurityExpression DropSecurityExpression DropSecurityExpression DropSecurityExpression 33

不可用。Not available.

DropService DropService DropService DropService 163

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

DropSynonym DropSynonym DropSynonym DropSynonym 36

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

DropTable DropTable DropTable DropTable 23

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

DropTrigger DropTrigger DropTrigger DropTrigger 73

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

DropType DropType DropType DropType 93

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

DropUser DropUser DropUser DropUser 133

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

DropView DropView DropView DropView 43

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

GrantObject GrantObject GrantObject GrantObject 170

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

GrantStatement GrantStatement GrantStatement GrantStatement 167

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

Insert Insert Insert Insert 1

已执行 INSERT Transact-SQL 语句。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

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

RevokeStatement RevokeStatement RevokeStatement RevokeStatement 169

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

Update Update Update 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.

适用于