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 databases 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

Parameter Description
name The name of the queue. The name can be schema-qualified.
IF EXISTS The 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;