Drops a queue table.

Syntax

DROP QUEUE TABLE [ IF EXISTS ] name [, ...] [CASCADE | RESTRICT]

Description

You can use the DROP QUEUE TABLE command to drop a queue table. Only a user with the aq_administrator_role privilege can run this command.

Note PolarDB for PostgreSQL(Compatible with Oracle) include extra syntax for the DROP QUEUE TABLE SQL command. The extra syntax is not offered by Oracle. You can use the syntax in association with DBMS_AQADM.

Parameters

ParameterDescription
nameThe name of the queue table to be deleted. The name can be schema-qualified.
IFEXISTSYou can include the IF EXISTS clause to instruct the server not to return an error if the queue table does not exist. Instead, the server issues a notice.
CASCADEYou can include the CASCADE keyword to automatically delete the objects that depend on the queue table.
RESTRICTYou can include the RESTRICT keyword to instruct the server not to delete the queue table if other objects depend on it. This is the default behavior.

Examples

The following example deletes a queue table whose name is work_order_table and the objects that depend on the queue table:

DROP QUEUE TABLE work_order_table CASCADE;