select name from sysobjects where xtype='TR' --所有触发器名称select name from sysobjects where xtype='P' --所有存储过程select name from sysobjects where xtype='V' --所有视图select name from sysobjects where xtype='U' --所有表 全部禁用:Alter table t1 disable trigger all;全部生效:Alter table t1 enable trigger all;单个禁用:Alter table t1 disable trigg...
select name 表格名称 from sysobjects where xtype='U'AND id in(select parent_obj from sysobjects where xtype='TR')------查询有触发器的表select name 表格名称 from sysobjects where xtype='U'A...