Disable foreign key : Drop Foreign Key « Constraints « Oracle PL / SQL

1. Oracle PL / SQL
2. Constraints
3. Drop Foreign Key

Disable foreign key

   

SQL>
SQL> create table it
  2   (c1 number primary key,
  3    c2 number,
  4    c3 number);



SQL>
SQL> alter table it add constraint it_fk foreign key (c2) references emp disable;



SQL>
SQL>
SQL> select object_name as name, object_id
  2  from user_objects
  3  where object_name in ('T', 'IT');

IT                                                                                                                            14971

1 row selected.

   
    
    
  

Related examples in the same category