删除表外键sql
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[D_FK]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[D] DROP CONSTRAINT D_FK
ALTER TABLE [dbo].[D] DROP CONSTRAINT D_FK
posted on 2007-12-04 09:46 littlebamboo 阅读(2005) 评论(0) 编辑 收藏 举报