Using Triggers |
|
Triggers are predefined commands that are automatically executed in response to specific events, regardless of which user or application program generated the events. Triggers allow you to customize your database in ways that may not be possible with standard SQL commands. You can use triggers to:
Implement business rules
Create an audit trail of database activities
Derive additional values from existing data
Replicate data across multiple tables
Perform security authorization procedures
Control data integrity
Define unconventional integrity constraints
In this section, you will create a trigger with various trigger options. Once this is done, you will drop a trigger from a database.
Related topic: