Stack Overflow
Stack Overflow

Questions tagged [cascading-deletes]

The concept of SQL databases deleting rows that refer (via a foreign key) to a deleted row.

The concept of SQL databases deleting rows that refer (via a foreign key) to a deleted row. The deletion is performed recursively and enabled with the ON DELETE CASCADE property of the foreign key.

587 questions
-2
votes
1 answer

DELETE CASCADE ON SQLITE ANDROID

I have 3 tables say A,B,C. Table A has primary key column a1 which is the foreign key for table B.Table B has primary key b1 and which is Foreign key for table C.Table C has primary key c1. I am deleting a row from Table A by cascade deleting. its…
Mathan
  • 49
  • 3
  • 10
-4
votes
1 answer

how to cascade delete rows from three tables in mysql by referencing a relationship

DELETE f.* FROM FILE f, topic t, course c WHERE f.topic_id = t.topic_id AND t.course_id = 28; DELETE t.* FROM topic t WHERE t.course_id = 28; DELETE c.* FROM course c WHERE c.course_id = 28; EDIT: The op wants to know (as indicated in the…
user3653924
  • 1
  • 2
1 2 3
…
39
40