ALTER TABLE MyTable NOCHECK CONSTRAINT MyFKConstraint
Swapping out NOCHECK with CHECK will enforce the fk constraint.
Although I think this behavior is reasonable, and even desirable it has put me on my heels more than once. Hopefully writing it down will keep me from forgetting again.
No comments:
Post a Comment