create table test (id int)go--test 表上的触发器create trigger tr on testafter insert asbegin print 'a'endgocreate trigger tr2 on testafter update asbegin print 'b'endgo--SQL 2005 删除指定表上的触发器 declare @s varchar(8000)set @s=''select @s=@s+','+t.namefrom sys.objects o join sys.triggers t on o.object_id=t.parent_idwhere o.name='test'select @s=replace(@s,',',' drop trigger ') exec(@s)go--依赖于test表的存储过程create proc pros1asbegin select * from testendgocreate proc pros2 asbegin select * from test order by id end go----SQL 2000/05 删除指定表依赖的存储过程 create table #k ( name varchar(100), [type] varchar(500) ) insert #k exec sp_depends 'test' declare @s varchar(8000) set @s='' select @s=@s+','+name from #k select @s=REPLACE(@s,',',' drop procedure ') exec(@s)