Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Table

 

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> select object_name as name, object_id   2  from user_objects   3  where object_name in ('T', 'IT'); IT                                                                                                                            14971 1 row selected.