Export (0) Print
Expand All


SQL Server 2000

By understanding how to create, modify, and maintain triggers, you can use triggers to:

  • Cascade changes through related tables in the database.

  • Disallow or roll back changes that violate referential integrity, thereby canceling the attempted data modification transaction.

  • Enforce restrictions that are more complex than those defined with CHECK constraints.

  • Find the difference between the state of a table before and after a data modification and take action(s) based on that difference.

See Also

Enforcing Business Rules with Triggers

© 2014 Microsoft