Skip Headers
Oracle® Database PL/SQL Language Reference
11g Release 2 (11.2)

Part Number E25519-05
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub
LNPLS99990

DROP TRIGGER Statement

The DROP TRIGGER statement drops a database trigger from the database.

LNPLS2029Topics

Prerequisites

The trigger must be in your schema or you must have the DROP ANY TRIGGER system privilege. To drop a trigger on DATABASE in another user's schema, you must also have the ADMINISTER DATABASE TRIGGER system privilege.

Syntax

LNPLS1728drop_trigger ::=

Description of drop_trigger.gif follows
Description of the illustration drop_trigger.gif

Semantics

LNPLS1729schema

Name of the schema containing the trigger. Default: your schema.

LNPLS1730trigger

Name of the trigger to be dropped.

Example

LNPLS1731Dropping a Trigger: Example This statement drops the salary_check trigger in the schema hr:

DROP TRIGGER hr.salary_check; 

Related Topics

Reader Comment

   

Comments, corrections, and suggestions are forwarded to authors every week. By submitting, you confirm you agree to the terms and conditions. Use the OTN forums for product questions. For support or consulting, file a service request through My Oracle Support.

Hide Navigation

Quick Lookup

Database Library · Master Index · Master Glossary · Book List · Data Dictionary · SQL Keywords · Initialization Parameters · Advanced Search · Error Messages

Main Categories

This Document

New and changed documents:
RSS Feed HTML RSS Feed PDF