1、禁用 table_name 表的所有 trigger
1
|
alter
table
table_name disable
all
triggers;
|
2、启用 table_name 表的所有 trigger
1
|
alter
table
table_name enable
all
triggers;
|
3、禁用指定 trigger
1
|
alter
trigger
trigger_name disable;
|
4、启用指定 trigger
1
|
alter
trigger
trigger_name enable;
|