Problem solution for script: Enforce Foreign Key Constraint to No on SQL2005

ALTER TABLE dbo.ECMD_tblRule WITH NOCHECK ADD CONSTRAINT

FK_EC_tblRule_EC_tblConnString FOREIGN KEY

(ACL_ConnID) REFERENCES dbo.ECMD_tblConnString

(ConnID) ON UPDATE  NO ACTION ON DELETE  NO ACTION

GO

ALTER TABLE dbo.ECMD_tblRule

NOCHECK CONSTRAINT FK_EC_tblRule_EC_tblConnString

posted on 2006-08-18 18:29  KADreams  阅读(198)  评论(0)    收藏  举报