Disable foreign key : FOREIGN KEY « Table « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. Table
3. 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.