Drops an existing queue.

Syntax

DROP QUEUE [IF EXISTS] name

Description

You can use the DROP QUEUE command to drop an existing queue. To run this command, you must be a user that has the aq_administrator_role privilege.

Note
PolarDB for PostgreSQL(Compatible with Oracle) provide the syntax of the DROP QUEUE SQL command that is not provided by Oracle. You can use this syntax together with DBMS_AQADM.

Parameters

ParameterDescription
ParameterDescription
nameThe name of the queue. The name can be schema-qualified.
IF EXISTSThe IF EXISTS clause instructs the server not to return an error even if the specified queue does not exist. If the specified queue does not exist, the server issues a notice.

Examples

Drop a queue whose name is work_order:

DROP QUEUE work_order;