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

3.删除所有存储过程

--3.删除所有存储过程
declare @sqlp varchar(8000) 
while (select count(*) from sysobjects where type='p')>0 
begin 
SELECT @sqlp='drop Procedure ' + name 
FROM sysobjects 
WHERE (type = 'p') 
ORDER BY 'drop Procedure ' + name 
exec(@sqlp) 
end

删除所有试图

--4.删除所有试图
declare @sqlv varchar(8000) 
while (select count(*) from sysobjects where type='v')>0 
begin 
SELECT @sqlv='drop View ' + name 
FROM sysobjects 
WHERE (type = 'v') 
ORDER BY 'drop View ' + name 
exec(@sqlv) 
end