CASCADE CONSTRAINTS in SQL

Question

Hi Friends I want to know about CASCADE CONSTRAINTS and how it is used in SQL ?

Akkiraju Ivaturi · Answer

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.