ALTER TIGGER trigger_name [DISABLE | ENABLE ];
ALTERTABLE[schema.]table_name {ENABLE|DISABLE} ALL TRIGGERS;
----example
alter table tar_station disable all triggers;
alter table tar_station enable all triggers;
ALTER TIGGER trigger_name [DISABLE | ENABLE ];
ALTERTABLE[schema.]table_name {ENABLE|DISABLE} ALL TRIGGERS;
----example
alter table tar_station disable all triggers;
alter table tar_station enable all triggers;
转载于:https://blog.51cto.com/ahead51/1201595