O'Reilly logo

SQL in a Nutshell by Kevin Kline

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Name

DROP TRIGGER

Synopsis

The DROP TRIGGER command removes a trigger for a table within the current database.

Vendor

Command

SQL Server

Supported, with variations

MySQL

Not supported

Oracle

Supported, with variations

PostgreSQL

Supported, with variations

SQL99 Syntax and Description

DROP TRIGGER trigger_name

DROP TRIGGER removes a trigger from the current database. MySQL does not support this command.

Microsoft SQL Server Syntax and Variations

DROP TRIGGER [owner_name.]trigger_name [,...n]
GO

Microsoft SQL Server allows multiple triggers to be dropped by placing a comma between each trigger name.

Oracle Syntax and Variations

DROP TRIGGER [owner_name.]trigger_name;

Oracle drops the indicated trigger and commits pending changes to the database when this command is executed.

PostgreSQL Syntax and Variations

DROP TRIGGER trigger_name ON table_name;

PostgreSQL requires that the table where the trigger resides is named. It then drops all references to an existing trigger when this command is executed.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required