How do I disable the restriction?

Question

I have a constraint (named INVS_ITEM_LOCATIONS_PK

) on my SQL Server 2005 table.

How do I disable it?

+2

sql-server-2005 constraints

Domnic 05 Sep '09 at 9:36

source to share

2 answers

I'm not sure if you can disable the restriction, maybe you need to SPECIFY the restriction?

+3

Mark redman 05 Sep '09 at 9:39

source to share

Domnic · Accepted Answer · 2009-09-05T09:55:47+0000

ALTER TABLE INVS_ITEM_LOCATIONS NOCHECK CONSTRAINT INVS_ITEM_LOCATIONS_PK