开发者

CHECK/NOCHECK for Sql Compact Edition

开发者 https://www.devze.com 2022-12-08 13:27 出处:网络
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

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

精彩评论

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

关注公众号