trigger in sqlserver

• . DML Triggers

Insert
create trigger afterinsert_trigger
on emp
AFTER INSERT
as
PRINT 'AFTER TRIGGER EXECUTED SUCESSFULLY'
GO
Update

create trigger afterupdate_trigger

on emp

AFTER UPDATE

as

PRINT 'AFTER UPDATE TRIGGER EXECUTED SUCESSFULLY'

GO

Delete

Create trigger afterdelete_trigger

On emp

AFTER DELETE

as

PRINT 'AFTER DELETE TRIGGER EXECUTED SUCESSFULLY'

GO

Instead of Delete Trigger

Creating INSTEAD OF DELETE TRIGGER:-
create trigger insteadofdelete_trigger
on emp
INSTEAD OF DELETE
as
PRINT 'INSTEAD OF DELETE TRIGGER EXECUTED SUCESSFULLY'
GO

HOW TO Drop a Trigger?

Syntax: DROP TRIGGER [triggername]

Eg: DROP TRIGGER afterinsert_trigger