Wednesday, January 7, 2009

Types and Categories of Triggers



Triggers are a group of SQL Statements linked with a table, which executes in response to a user query which intends to make changes in the data of that table. Thus, these queries must be from Insert, Update or Delete.

Triggers are of two categories:
1. DML triggers (Data Manipulation Triggers)
2. DDL Triggers (Data Definition Triggers)

No comments: