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
- 继承
字段
| 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.