DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: what is the command to disable foreign key?

  1. 03-06-2002, 01:56 PM #1
    tang
    tang is offline Junior Member
    Join Date
    Jan 2002
    Posts
    28
    Hi,

    Does anyone know what is the command to disable foreign key constraint? Thanks.
    Reply With Quote Reply With Quote
  2. 03-06-2002, 02:20 PM #2
    np70
    np70 is offline Junior Member
    Join Date
    Mar 2001
    Posts
    71
    alter table "table1" disable constraint "constraint_name";
    Reply With Quote Reply With Quote
  3. 03-06-2002, 02:25 PM #3
    Shestakov
    Shestakov is offline Senior Advisor
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    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.

    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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