Disable unique key constraint
448225Sep 17 2009 — edited Sep 18 2009Hi,
Is it possible to disable a unique key constraint?
I've tried following code:
ALTER TABLE table_name
DISABLE CONSTRAINT uk_constraint_name
which seems to work fine, but when I try to insert or update a record the unique constraint is still on. However in Toad the UK is marked as disabled.
Do I have to drop the UK and recreate it after my updates?
Thanks