drop trigger

Syntax

drop trigger [owner.]trigger_name 
	[, [owner.]trigger_name] ...

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.

Example 1 – 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, the SAP ASE server automatically drops any triggers associated with it.
You can use drop trigger to remove or replace an existing trigger, or multiple triggers. The drop trigger command drops a single trigger. If you have multiple triggers on a table, you can drop them individually.

See also sp_depends, sp_help, sp_helptext in Reference Manual: Procedures.

ANSI SQL – Compliance level: Transact-SQL extension.

The permission checks for drop trigger differ based on your granular permissions settings.

Setting	Description
Enabled	With granular permissions enabled, you must be the trigger owner or a user with `drop any trigger` privilege.
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:

Information	Values
Event	29
Audit option	drop
Command or access audited	drop trigger
Information in `extrainfo`	Roles – current active roles Keywords or options – NULL Previous value – NULL Current value – NULL Other information – NULL Proxy information – original login name, if set proxy is in effect