select * from sysobjects where xtype='TR' and parent_obj=object_id('表名')
再用sp_helptext '触发器名' 查内容 比如:exec sp_helptext 'Trig_Group_Delete'
select * from sysobjects where xtype='TR' and parent_obj=object_id('表名')
再用sp_helptext '触发器名' 查内容 比如:exec sp_helptext 'Trig_Group_Delete'