-
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
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
|