删除sqlserver 数据库外键remove all the db foreign key
2012-12-06 16:06 小草生活 阅读(232) 评论(0) 编辑 收藏 举报remove all the db foreign key
use GEMS
go
while(exists(select 1 from INFORMATION_SCHEMA.TABLE_CONSTRAINTS where CONSTRAINT_TYPE='FOREIGN KEY'))
begin
declare @sql nvarchar(2000)
SELECT TOP 1 @sql=('ALTER TABLE ' + TABLE_SCHEMA + '.[' + TABLE_NAME
+ '] DROP CONSTRAINT [' + CONSTRAINT_NAME + ']')
FROM information_schema.table_constraints
WHERE CONSTRAINT_TYPE = 'FOREIGN KEY'
exec (@sql)
end
select * from INFORMATION_SCHEMA.TABLE_CONSTRAINTS