Target table T1 is getting deleted. Table T2 has the foreign key. We require that whenever a row from T1 is deleted, the corresponding row from T2 also be deleted. Which option can be used?
ON DELETE RESTRICT
ON DELETE CASCADE
ON DELETE SET NULL
ON DELETE CHILD
ON DELETE MATCH