Syntax:
create trigger [trigger_name]
[before | after]
{insert | update | delete}
on [table_name]
[for each row]
as [print/select]
Example:
create trigger myDel
on tbl_pro
after delete
as
select * from tbl_product
print 'Record Deleted successfully!!!'