Skip to Main Content
SQL in a Nutshell
book

SQL in a Nutshell

by Kevin Kline
December 2000
Intermediate to advanced content levelIntermediate to advanced
224 pages
9h 52m
English
O'Reilly Media, Inc.
Content preview from SQL in a Nutshell

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.

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

SQL in a Nutshell, 3rd Edition

SQL in a Nutshell, 3rd Edition

Kevin Kline

Publisher Resources

ISBN: 1565927443