[RESOLVED] Deleting db row with Foreign Key Constraints

[endurox]

I have two tables:

patient_captures TABLE

capture_id |  captured   | patient_id
-----------------------------------------------------------------
     1     | 3/12/2009   |       9

patient_procedures TABLE

procedure_id | capture_id | performed | cpt
-----------------------------------------------------------------
     1       |      1     | 3/1/2009  | 93010
     2       |      1     | 3/2/2009  | 93356
     3       |      1     | 3/3/2009  | 93357

I've setup a foreign key with Capture_id on both tables. What SQL statement or php code would I use to delete the capture_id 1 in table patient_captures along with its corresponding patient_procedures?

Thanks for any assistance on this issue. If you need more information, just ask.

[laserlight]

If the foreign key constraint for patient_procedures has ON DELETE CASCADE, then you do not need to do anything extra.

[endurox]

YUP, THANK YOU!