Getting Started with Adobe After Effects - Part 6: Motion Blur
This module helps you to share, discuss and learn interview questions and answers of different technologies

What are DDL Triggers?

Nov 17 2011 10:01AM by Vivek Johari   

Question

What are DDL Triggers?

Answer

DDL Triggers has the similar behavior as the DML triggers to have except that they are fired in response to a DDL type event like Alter command, Drop command and Create commands. In other words, it will fire in response to the events which try to change the schema of the database. Therefore, these triggers are not created for a particular table, but they are applicable to all the tables on the database. Also DDL triggers can be fired only after the commands which make them fire is executed. They can be used for the following purposes:

1) To prevent any changes to the database Schema

2) If we want to store the records of all the events, which change the database schema.

Read More..   [1055 clicks]

Published under: SQL Server Interview Questions ·  ·  ·  · 


Vivek Johari
116 · 1% · 445
0
Liked
 
0
Asked



Submit

Your Comment


Sign Up or Login to post a comment.

"What are DDL Triggers? " rated 5 out of 5 by 2 readers
What are DDL Triggers? , 5.0 out of 5 based on 2 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]