Deletes a Trigger.

DROP TRIGGER is an online operation. So, this operation can be performed while users are still connected to the database. However, there are two cases where this operation is not online. They are mentioned in the Exception section.

Online DROP TRIGGER provides high concurrency when compared to other online operations. For example:

  • When online DROP TRIGGER of a table is being executed in one transaction, users in other transactions are not allowed to perform INSERT/UPDATE/DELETE operations on that table and are allowed to only perform the SELECT operation on that table. There are no restrictions on other tables.

Exception

You cannot perform online operation of DROP TRIGGER statement if:

  • The table on which trigger is defined is in PUB schema.
  • The database is enabled for replication.

Syntax

DROP TRIGGER [owner_name.]trigger_name ;

Parameters

owner_name

Specifies the owner of the trigger.

trigger_name

Names the trigger to drop.

Example

The following is an example of the DROP TRIGGRER statement:

DROP TRIGGER sal_check ;