Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

'on delete cascade' option 1

Status
Not open for further replies.
rajsrivatsa9

rajsrivatsa9

Technical User
Jun 19, 2001
10
IN
If I use ondelete cascade in the child table, can this table have any references with another table..? For eg.. Customer table is a parent of Cust_products table. The I have a Product master table. If I provide 'ondelete cascade' in Cust_products table which refers both Customer table and Product master table.., How the system will accept..?
Please guide me..!
 
Sort by date Sort by votes
The simple answer is yes. If you have a on dlete cascade from a to b and then B to C, deleteing from a will cause records from B and C to be deleted.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Chopstik
  • Locked
  • Question
How to identify a package based on a code snippet 1
Replies
1
Views
325
Andrzejek
Andrzejek
Andrzejek
  • Locked
  • Question
Detect ON DELETE CASCADE in tables 1
Replies
4
Views
170
Andrzejek
Andrzejek
Livia8
  • Locked
  • Question
Can deleted files/ directories (rm -r) be retrieved again?
Replies
6
Views
230
Livia8
Livia8
sa0309
  • Locked
  • Question
Case expression in the WHERE clause of a delete statment
Replies
2
Views
85
carp
carp
Livia8
  • Locked
  • Question
Generate report/output on the basis of "enquiry" responsibilities only 1
Replies
16
Views
176
Livia8
Livia8

Part and Inventory Search

Sponsor

Back
Top