senthilssg
New User
Joined: 09 Dec 2005 Posts: 64 Location: USA
|
|
|
|
Hi kaurav,
Quote: |
Pls let me know the effects of ON DELETE RESTRICT and ON DELETE NO ACTION option on Referential constraints |
what the difference is between the NO ACTION and RESTRICTED options?
The answer is that the NO ACTION option will wait until all triggers defined for the table have been executed.
you can refer this link for the details .
http://www.itjungle.com/mpo/mpo021303-story02.html
ON DELETE RESTRICT: disallows the deletion of the primary key row if any foreign keys relate to the row.
ON DELETE NO ACTION: the behavior of NO ACTION is similar to RESTRICT. The only difference between RESTRICT and NO ACTION is when the referential constraint is enforced. RESTRICT enforces the delete rule immediately; NO ACTION enforces the delete rule at the end of the statement.
you can get the details of this from following link .
http://www.dbazine.com/db2/db2-mfarticles/mullins1/
Regards ,
senthil
'CORRECT ME I 'M WRONG' |
|