Thursday, October 25, 2012

Have you created any? What did they do? When is a trigger fired?


Have you created any? What did they do? When is a trigger fired?

 Trigger fired when DML and DDL operation occurs in table. They are used for data integrity of the tables and many more.
I have created a trigger to capture the update, delete and insert data of main table to our Archive table. So if we change any data in main table then these data automatically saved in Archive table

No comments:

Post a Comment