--禁用所有
alter table [tablename]
disable trigger all
--恢复所有
alter table [tablename]
enable trigger all
--禁用指定
alter table [tablename]
disable trigger [triggername]
--恢复指定
alter table [tablename]
enable trigger [triggername]
alter table [tablename]
disable trigger all
--恢复所有
alter table [tablename]
enable trigger all
--禁用指定
alter table [tablename]
disable trigger [triggername]
--恢复指定
alter table [tablename]
enable trigger [triggername]