TRIGGER in sqlserver

CREATE TRIGGER triggerName ON table AFTER INSERT |After Delete |After Upadte AS BEGIN INSERT INTO dbo.User END ========================================= DML Instead of Trigger: An Instead of trigger is fired instead of the triggering action such as an insert, update, or delete After Trigger: An After trigger executes following the triggering action, such as an insert, update or delete ========================================= DDL Trigger This type of trigger is fired against DDL statements like Drop Table, Create Table or Alter Table. DDL Triggers are always After Triggers.