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)

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!