sql 删除所有表

1.删除外键约束 

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 @sql varchar(8000) 
while (select count(*) from sysobjects where type='U')>0 
begin 
SELECT @sql='drop table ' + name 
FROM sysobjects 
WHERE (type = 'U') 
ORDER BY 'drop table ' + name 
exec(@sql) 
end

两个代码片复制到一块，然后执行就好了