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 trigger1 from the current database:
drop trigger trigger1
drop trigger drops a trigger in the current database.
You need not 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.
ANSI SQL – Compliance level: Transact-SQL extension.
The permission checks for drop trigger differ based on your granular permissions settings.
Granular permissions enabled |
With granular permissions enabled, you must be the trigger owner or a user with drop any trigger privilege. |
Granular permissions disabled |
With granular permissions disabled, you must be the trigger owner or a user with sa_role. |
Values in event and extrainfo columns of sysaudits are:
Event |
Audit option |
Command or access audited |
Information in extrainfo |
|---|---|---|---|
29 |
drop |
drop trigger |
|
Commands create trigger
System procedures sp_depends, sp_help, sp_helptext
