1. What is the significance of having names for key constraints? In what sense are they useful?
2. ON DELETE CASCADE works with the FOREIGN KEY. But why ON DELETE NO ACTION is giving error? It is providing error while I am running the script... but somehow the actual job of NO ACTION is working!!