Oracle7 Server SQL Reference

DROP TRIGGER

Purpose

To remove a database trigger from the database.

Prerequisites

The trigger must be in your own schema or you must have DROP ANY TRIGGER system privilege.

If you are using Trusted Oracle7 in DBMS MAC mode, your DBMS label must match the trigger's creation label or you must satisfy one of the following criteria:

If the trigger's creation label is higher than your DBMS label, you must have READUP and WRITEUP system privileges

If the trigger's creation label is lower than your DBMS label, you must have WRITEDOWN system privilege.

If the trigger's creation label and your DBMS label are not comparable, you must have READUP, WRITEUP, and WRITEDOWN system privileges.

Syntax

Keywords and Parameters

schema

is the schema containing the trigger. If you omit schema, Oracle7 assumes the trigger is in your own schema.

trigger

is the name of the trigger to be dropped.

Usage Notes

When you drop a database trigger, Oracle7 removes it from the database and does not fire it again.

Example

The following statement drops the REORDER trigger in the schema RUTH:

DROP TRIGGER ruth.reorder