-
Hi,
Does anyone know what is the command to disable foreign key constraint? Thanks.
-
alter table "table1" disable constraint "constraint_name";
-
alter table modify constrain FK_CONST disable [validate/nivalidate].
Remember:
If you disable a unique or primary key constraint that is using a unique index, Oracle drops the unique index.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|