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

/*第一步删除约束*/DECLARE c1 cursor forselect 'alter table ['+ object_name(parent_obj) + '] drop constraint ['+name+']; 'from sysobjectswhere xtype = 'F'open c1declare @c1 varchar(8000)fetch next from c1 into @c1while(@@fetch_status=0)beginexec(@c1)fetch next from c1 into @c1endclose c1deallocate 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步清空所有的存储过程*/

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