Triggers

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