--SQL2005下 SELECT * FROM sys.triggers select b.name ,a.text from syscomments a,sysobjects b where object_id(b.name)=a.id and b.xtype= 'TR'--可以查出触发器和他的语句
use 库名 SELECT * FROM sys.triggers
你这在MSSQL 2000下会报错的,只能在MSSQL 2005下 我下面这个语句在MSQL 2000下可以运行select b.name ,a.text from syscomments a,sysobjects b where object_id(b.name)=a.id and b.xtype= 'TR'--可以查出触发器和他的语句
SELECT * FROM sys.triggers
--SQL2005下
SELECT * FROM sys.triggers
select b.name ,a.text from syscomments a,sysobjects b where object_id(b.name)=a.id and b.xtype= 'TR'--可以查出触发器和他的语句
SELECT * FROM sys.triggers
我下面这个语句在MSQL 2000下可以运行select b.name ,a.text from syscomments a,sysobjects b where object_id(b.name)=a.id and b.xtype= 'TR'--可以查出触发器和他的语句