DROP QUEUE v15

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;

See also

CREATE QUEUE, ALTER QUEUE