Hi ,

normally we create th foreign keys like follows

SQL> create table indextest (id number,name varchar2(10));

Table created.

SQL> alter table indextest add constraint id_pk primary key (id);

Table altered.

SQL> create table indextest1 (id number,birthdate date);

Table created.

SQL> alter table indextest1 add constraint id_fk foreign key (id) references indextest(id);

Table altered.


but in some application i have observed the following query

SQL> ALTER TABLE indextest1 ADD CONSTRAINT id_fk FOREIGN KEY (id) REFERENCES indextest INITIALLY DEFERRED DEFERRABLE;


what is INITIALLY DEFFERED DEFERRABLE? And what it will do?


Thanks for any help


SrinivasM