How to Maintain?

• Policies for handling the change…

  • Reject the update (default)
  • Cascade (example: cascading deletes)
  • Set NULL

• Can set update and delete actions independently in CREATE TABLE

MovieName CHAR(30)

REFERENCES Movies(MovieName))

ON DELETE SET NULL

ON UPDATE CASCADE

Previous slide

Next slide

Back to first slide

View graphic version