Home » RDBMS Server » Server Administration » require solution for Deleting from Tables urgent....
require solution for Deleting from Tables urgent.... [message #372160] Wed, 17 January 2001 06:30 Go to next message
Satya
Messages: 36
Registered: January 2001
Member
How to delete data from all_tables with single
sql statement which has parent and child
records?

Report message to a moderator

Re: require solution for Deleting from Tables urgent.... [message #372162 is a reply to message #372160] Wed, 17 January 2001 09:30 Go to previous message
Jan G
Messages: 6
Registered: December 2000
Junior Member
If you created your foreign key with "on delete cascade" option, I believe you s/b ok.

Report message to a moderator

Previous Topic: inner joint
Next Topic: Exponent
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed May 15 15:23:05 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.