DROP QUEUE v17
EDB Postgres Advanced Server includes syntax not offered by Oracle with the DROP QUEUE SQL command. You can use this syntax with DBMS_AQADM.
Name
DROP QUEUE — Drop an existing queue.
Synopsis
Use DROP QUEUE to drop an existing queue:
DROP QUEUE [IF EXISTS] <name>
Description
DROP QUEUE allows a superuser or a user with the aq_administrator_role privilege to drop an existing queue.
Parameters
name
The name (possibly schema-qualified) of the queue that's being dropped.
IF EXISTS
Include the IF EXISTS clause if you don't want to return an error if the queue doesn't exist. Instead, issue a notice.
Examples
This example drops a queue named work_order:
DROP QUEUE work_order;