What is the difference between DDL and DMLtriggers?

Posted by Neeks under Sql Server on 2/7/2009 | Views : 10254 | Status : [Member] | Replies : 6

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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: Muhsinathk on: 6/12/2012 [Member] Bronze | Points: 25

0	http://blog.sqlauthority.com/2008/01/15/sql-server-what-is-dml-ddl-dcl-and-tcl-introduction-and-examples/ http://rahulgbhatia.wordpress.com/2012/03/28/what-are-the-difference-between-ddl-dml-and-dcl-commands/ Neeks, if this helps please login to Mark As Answer. \| Alert Moderator

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

0	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

0	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

0	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

0	Thanks Raja. Neeks, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts