1.

What Does The On Update No Action Do?

Answer»

ON UPDATE NO ACTION:

  • Specifies that if an ATTEMPT is made to update a key value in a row whose key is referenced by foreign KEYS in existing rows in other tables, an error is raised and the UPDATE is rolled back.
  • Specifies that if an attempt is made to DELETE a row with a key referenced by foreign keys in existing rows in other tables, an error is raised and the DELETE is rolled back.

ON UPDATE NO ACTION:


Discussion

No Comment Found

Related InterviewSolutions