--查看当前库中所有的触发器:SELECT * FROM Sysobjects WHERE xtype = ‘TR‘--查看当前库中所有的触发器和与之相对应的表：SELECT tb2.name AS tableName,tb1.name AS triggerName FROM Sysobjects tb1 JOIN Sysobjects tb2 ON tb1.parent_obj=tb2.id WHERE tb1.type=‘TR‘--显示触发器的定义:EXEC sp_helptext ‘触发器名‘--查看触发器的有关信息:EXEC sp_help ‘触发器名‘--查看表中的触发器类型:EXEC sp_helptrigger ‘表名‘