CODEWITHSUNDEEP
sql-server-2005constraints
Domnic
Domnic

Reputation: 3867

How can I disable a constraint?

I have a constraint (named INVS_ITEM_LOCATIONS_PK) in my SQL Server 2005 table.

How can I disable it?

Upvotes: 2

Views: 920

Answers (2)

Domnic
Domnic

Reputation: 3867

ALTER TABLE INVS_ITEM_LOCATIONS NOCHECK CONSTRAINT INVS_ITEM_LOCATIONS_PK

Upvotes: 0

Mark Redman
Mark Redman

Reputation: 24515

I am not sure if you can DISABLE a constraint, maybe you need to DROP the constraint?

Upvotes: 3

Related Questions