Subject | Foreign key definitions |
---|---|
Author | Jiri Cincura |
Post date | 2007-04-26T11:08:54Z |
Hi *,
is there any difference in behavior of these two statements:
alter table detail add foreign key (id2) references master;
and
alter table detail add foreign key (id2) references master on update no
action on delete no action;
?
Thanks Jiri.
--
Jiri {x2} Cincura
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
is there any difference in behavior of these two statements:
alter table detail add foreign key (id2) references master;
and
alter table detail add foreign key (id2) references master on update no
action on delete no action;
?
Thanks Jiri.
--
Jiri {x2} Cincura
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com