日期:2014-05-18 浏览次数:20459 次
CREATE PROCEDURE sp_drop_all_fk as declare @sql varchar(255) declare dropsql_cursor cursor for select 'alter table '+object_name(fkeyid)+' drop constraint '+object_name(constid)+char(10) from sysreferences open dropsql_cursor fetch dropsql_cursor into @sql begin tran while @@fetch_status=0 begin execute(@sql) if @@error <> 0 begin rollback return end fetch dropsql_cursor into @sql end deallocate dropsql_cursor commit GO exec sp_drop_all_fk -- 执行存储过程 2、删除表 declare @table varchar(400) while (select count(*) from sysobjects where type='u')>=1 begin set @table=(select top 1 name from sysobjects where type='u') set @table='drop table '+@table exec(@table) end select name,type from sysobjects where type='u' 本文来自CSDN博客,转载请标明出处:http://blog.csdn.net/js_szy/archive/2009/08/29/4496010.aspx
------解决方案--------------------
sp_MSforeachtable @command1 = "TRUNCATE TABLE ?"