TriggerAction 列舉

定義

TriggerAction 列舉型別 (Enumeration) 由 SqlTriggerContext 類別使用,以指示何種動作引發了觸發程序 (Trigger)。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 陳述式 (Statement)。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 物件權限 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 列舉型別 (Enumeration) 由 SqlTriggerContext 類別使用,以指示何種動作引發了觸發程序 (Trigger)。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.

適用於