CASCADE CONSTRAINTS in SQL

If you have an employee table and employee accounts table, deleting an employee record will automatically deletes all the accounts for that employee in the employee accounts table. You do not need to delete the employee accounts manually.

If you have cascade delete setup.