We have a parent-child relationship table with foreign key and primary key constraints. How would you delete a specific row in the child table?

To delete a specific child row, first ensure that the foreign key constraint does not prevent the operation. If the foreign key is defined with ON DELETE CASCADE, deleting the parent will automatically remove the child rows, but for a single child you can run a DELETE statement with a WHERE clause that uniquely identifies the row, e.g., DELETE FROM child_table WHERE child_id = 123. If the foreign key is NOT NULL and the child has a reference to the parent, the delete will succeed as long as the parent still exists. If you need to maintain referential integrity and avoid orphaned rows, wrap the delete in a transaction and optionally use SELECT FOR UPDATE to lock the row. After deletion, you can commit the transaction. If the foreign key is set to RESTRICT or NO ACTION, the delete will fail if any other tables reference the child row, so you must first delete or update those dependent rows.