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 plaincopydeclare @proctname varchar(8000)  select @proctname =@proctname+ Name + ',' from sysobjects where xtype='P'  select @proctname='drop Procedure ' + left(@proctname,len(@proctname)-1)  exec(@proctname)