开发者

CHECK/NOCHECK for Sql Compact Edition

I am attempting to wipe and repopulate test data on SQL CE. I am getting an error due to FK constraints existing. Typically in Sql2005 I would

ALTER TABLE [tablename] CHECK/NOCHECK CONSTRAINT ALL
to enable/disable all constraints. From what I could find in my searching, it seems 开发者_StackOverflowthat this might not be supported in CE. Is that true? If so, is there an alternative?


NOCHECK is not supported on SQL CE 3.1/3.5

ALTER TABLE SQL CE

The usual method to accomplish this is to drop the constraint, do your operations and then add it back.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜