sql server查询某个表对应的触发器
sql语句如下
select * from sysobjects where xtype='TR'
select * from sysobjects where xtype='TR' and parent_obj=object_id('T_YNCS_BillQuantities_EN') --T_YNCS_BillQuantities_EN为表名
sql语句如下
select * from sysobjects where xtype='TR'
select * from sysobjects where xtype='TR' and parent_obj=object_id('T_YNCS_BillQuantities_EN') --T_YNCS_BillQuantities_EN为表名