Delete cascade.

shankari · New User Joined: 29 Jul 2005 Posts: 1

HI,
Can anybody plz clarify this?

On Delete Cascade - will delete the corresponding rows in both parent table as well as dependent table

or

- will delete the row in dependent table only.

plz clear my doubt.

thank u .
shankari

sarath_ibm · New User Joined: 03 Aug 2005 Posts: 14 Location: hyderabad

On Delete Cascade - will delete the corresponding rows in both parent table as well as dependent table .only on Delete Restrict delete first child table after that u will be able to delete parent table.