Question

Explain what Is The Difference Between Alter Trigger And Drop Trigger Statements?

Answer 1

An ALTER TRIGGER statement is used to recompile, disable, or enable a trigger; whereas, the DROP TRIGGER statement is used to remove the trigger from the database.