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
Parameter | Description |
---|---|
name | The name of the queue table to be deleted. The name can be schema-qualified. |
IFEXISTS | You 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. |
CASCADE | You can include the CASCADE keyword to automatically delete the objects that depend on the queue table. |
RESTRICT | You 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;