Home

	Expand Search

Reference Manual: Commands

Chapter 1 Commands

drop trigger

drop trigger

Description

Removes a trigger.

Syntax

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

Parameters

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.

Examples

Example 1

Removes the trigger trigger1 from the current database:

drop trigger trigger1

Usage

• 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.

Standards

ANSI SQL - Compliance level: Transact-SQL extension.

Permissions

drop trigger permission defaults to the trigger owner and is not transferable.

See also

Commands

create trigger

System procedures

sp_depends, sp_help, sp_helptext