A DDL trigger is fired in response to DDL statements, such as CREATE TABLE or ALTER TABLE. DDL triggers can be used to perform administrative tasks, such as database auditing.
Database auditing helps in monitoring the DDL operat...
Sunday, February 1, 2015
Sunday, November 9, 2014
Implementing Triggers and its Types in SQL
In a relational database, data in a table is related to other tables. Therefore, while manipulating data in one table, you need to verify and validate its effect on data in the related tables. In addition, you might need to manip...