SQLserver 删除数据所有表和存储过程和约束

/第一步删除约束/

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 

–/第2步**删除所有表*****************/

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)  

/第3步清空所有的存储过程/

[sql] view plaincopy
declare @proctname varchar(8000)  
select @proctname =@proctname+ Name + ',' from sysobjects where xtype='P'  
select @proctname='drop Procedure ' + left(@proctname,len(@proctname)-1)  
exec(@proctname)