Translate to Tamil

Best Offers

Bigbasket [CPS] IN

Amazon Best Offers

Amazon Offers

Offers

Online Income

Best Online Offers

Wikipedia

Search results

Wednesday, 5 January 2011

What are the Different Types of Triggers?


There are two types of Triggers.

1)  DML Trigger

There are two types of DML Triggers

  • Instead  of Trigger
                Instead of Triggers are fired in place of the triggering action such as an insert, update, or delete.

  • After Trigger
              After triggers execute following the triggering action, such as an insert, update, or delete.

2)   DDL Trigger
This type of trigger is fired against Drop Table, Create Table, Alter Table or Login events. DDL Triggers are always After Triggers.

 Share This Post


No comments:
Write comments

Infolinks

Services

© 2014