1.删除外键约束
DECLARE c1 cursor for select 'alter table ['+ object_name(parent_obj) + '] drop constraint ['+name+']; ' from sysobjects where xtype = 'F' open c1 declare @c1 varchar(8000) fetch next from c1 into @c1 while(@@fetch_status=0) begin exec(@c1) fetch next from c1 into @c1 end close c1 deallocate c1 go
2.删除所有存储过程
use 数据库名 declare @tname varchar(8000) set @tname='' select @tname=@tname + Name + ',' from sysobjects where xtype='P' select @tname='drop Procedure ' + left(@tname,len(@tname)-1) exec(@tname) go
3.删除所有表
use 数据库名 declare @tname varchar(8000) set @tname='' select @tname=@tname + Name + ',' from sysobjects where xtype='U' select @tname='drop table ' + left(@tname,len(@tname)-1) exec(@tname) go
原文地址:http://www.cnblogs.com/huangjianwu/p/4536619.html