Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
IGNORING FOREIGN KEYS
Message
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
00449631
Message ID:
00449898
Views:
14
>For a temporary fix, it's easier to instruct SQL Server to stop checking enforcing the constriant.
>
>ALTER TABLE tablename NOCHECK CONSTRAINT constraintname
>
>Enable enforcement with this:
>
>ALTER TABLE tablename CHECK CONSTRAINT constraintname
>
>-Mike

Thanks.
Chris McCandless
Red Sky Software
Previous
Reply
Map
View

Click here to load this message in the networking platform