岀電于工業用 ALTER TRIGGER命令修改触发器,其语法格式为 ALTER TRIGGER trigger_name on(table I view) L WITH ENCRYPTION ti FOR AFTER INSTEAD OFI[ DELETE][,][ INSERT I[ UPDATE] I NOT FOR REPLICATION AS sql_statement[…n]} I FOR AFTER INSTEAD OF IL INSERT][,][ UPDATE]] I NOT FOR REPLICATION AS tIF UPDATE(column) AND I OR) UPDATE(column) COLUMNS UPDATED O bitwise_operator ]updated_bitmask t comparison_operator) column_ bitmask [.n sql_statement[…n] 返回目录• （2）利用ALTER TRIGGER命令修改触发器, 其语法格式为： • ALTER TRIGGER trigger_name • ON (table | view) • [ WITH ENCRYPTION ] • { { FOR | AFTER | INSTEAD OF { [ DELETE ] [ , ] [ INSERT ] [ , ][ UPDATE ] } • [ NOT FOR REPLICATION ] • AS • sql_statement [ ...n ] } • | { FOR | AFTER | INSTEAD OF { [ INSERT ] [ , ] [ UPDATE ] } • [ NOT FOR REPLICATION ] • AS • { IF UPDATE (column) • [ { AND | OR } UPDATE(column) ] • [ ...n ] • |IF COLUMNS_UPDATED (){ bitwise_operator }updated_bitmask • { comparison_operator } column_bitmask [ ...n ] • } • sql_statement [ ...n ] • }} 返回目录