Advertisement

Triggers-the Hidden Stored Procedures

  • Itzik Ben-Gan
  • Tom Moreau

Abstract

Triggers allow you to enforce referential integrity (RI) and domain integrity programmatically, handle physicalization (physical implementation) of logical tables, and implement weird business rules (you’ve seen those, haven’t you?). Alternatively, you can enforce strange business rules through stored procedures—the choice is up to you. Stored procedures are discussed in Chapter 9.

Keywords

Base Table Delete Statement Referential Integrity Order Table Insert Statement 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Itzik Ben-Gan and Tom Moreau 2000

Authors and Affiliations

  • Itzik Ben-Gan
  • Tom Moreau

There are no affiliations available

Personalised recommendations