以下是删除一个数据库中所有的触发器--触发器 DECLARE @STRING VARCHAR(8000) WHILE EXISTS(SELECT NAME FROM SYSOBJECTS WHERE XTYPE='TR') BEGIN SELECT @STRING='DROP TRIGGER '+NAME+ CHAR(13) FROM SYSOBJECTS WHERE XTYPE='TR' EXEC(@STRING) ENDGO
噢,楼主的意思是删除一个表的所有触发器 那么,稍微修改一下即可--触发器 DECLARE @STRING VARCHAR(8000) WHILE EXISTS(SELECT NAME FROM SYSOBJECTS WHERE XTYPE='TR' and name=你的表) BEGIN SELECT @STRING='DROP TRIGGER '+NAME+ CHAR(13) FROM SYSOBJECTS WHERE XTYPE='TR' and name=你的表 EXEC(@STRING) ENDGO
USE YOUR_DB SELECT NAME FROM SYSOBJECTS WHERE XTYPE='TR' AND NAME = 'TABLE_NAME' 如果有数据 DROP TRIGGER ...
alter table 表名 disable trigger all
DECLARE @STRING VARCHAR(8000)
WHILE EXISTS(SELECT NAME FROM SYSOBJECTS WHERE XTYPE='TR')
BEGIN
SELECT @STRING='DROP TRIGGER '+NAME+ CHAR(13) FROM SYSOBJECTS WHERE XTYPE='TR'
EXEC(@STRING)
ENDGO
那么,稍微修改一下即可--触发器
DECLARE @STRING VARCHAR(8000)
WHILE EXISTS(SELECT NAME FROM SYSOBJECTS WHERE XTYPE='TR' and name=你的表)
BEGIN
SELECT @STRING='DROP TRIGGER '+NAME+ CHAR(13) FROM SYSOBJECTS WHERE XTYPE='TR' and name=你的表
EXEC(@STRING)
ENDGO
SELECT NAME FROM SYSOBJECTS WHERE XTYPE='TR' AND NAME = 'TABLE_NAME'
如果有数据
DROP TRIGGER ...