Drops a queue table.
DROP QUEUE TABLE [ IF EXISTS ] name [, ...] [CASCADE | RESTRICT]
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.
DROP QUEUE TABLESQL command. The extra syntax is not offered by Oracle. You can use the syntax in association with DBMS_AQADM.
|name||The name of the queue table to be deleted. The name can be schema-qualified.|
|IFEXISTS||You can include the
|CASCADE||You can include the
|RESTRICT||You can include the
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;