Removes a trigger.
drop trigger [owner.]trigger_name [, [owner.]trigger_name] ...
is the name of the trigger to drop. Specify the owner’s name to drop a trigger of the same name owned by a different user in the current database. The default value for owner is the current user.
Removes the trigger trigger1 from the current database:
drop trigger trigger1
drop trigger drops a trigger in the current database.
You do not need to explicitly drop a trigger from a table to create a new trigger for the same operation (insert, update, or delete). In a table or column each new trigger for the same operation overwrites the previous one.
When a table is dropped, Adaptive Server automatically drops any triggers associated with it.
SQL92 – Compliance level: Transact-SQL extension.
drop trigger permission defaults to the trigger owner and is not transferable.
Commands create trigger
System procedures sp_depends, sp_help, sp_helptext