What is the difference between DDL and DMLtriggers?

Posted by Neeks under Sql Server on 2/7/2009 | Views : 10488 | Status : [Member] | Replies : 6
Can anyone tell me the difference between DDL and DML triggers? I want to us the trigger. So please provide the examples if it is possible.
Thanks in Advance




Responses

Posted by: Sriramnandha on: 5/25/2012 [Member] Starter | Points: 25

Up
0
Down
DDL(DATA DEFINATION LANGUAGE)

CREATE ,DELETE

DML(DATA MANUPULATION LANGUAGE)

INSERT,UPDATE,DELETE

DDL TRIGGER IS USED FOR CREATE TABLE,DELETE TABLE
DML TIGGER IS USED INSERT,UPDATE,DELETE

REGARDS


sriram

Neeks, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Ravianand on: 6/12/2012 [Member] Starter | Points: 25

Up
0
Down
Refer below link
http://www.linkedin.com/answers/technology/information-technology/information-security/TCH_ITS_ISC/804231-16576065



Regards,
Ravi

Neeks, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Raja on: 2/8/2009 [Member] Starter

Up
0
Down
DDL is Data Definitaion Langauge and it contains command like Create Table, Drop table etc. Where DDL Trigger is a kind of triggers that contains command like Create trigger, update triggers etc.

For complete understanding, please visit http://www.developer.com/db/article.php/3552096

Thanks

Regards,
Raja, USA

Neeks, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Neeks on: 2/8/2009 [Member] Bronze

Up
0
Down
This helped me lot.

Neeks, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Neeks on: 2/8/2009 [Member] Bronze

Up
0
Down
Thanks Raja.

Neeks, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response