DROP QUEUE TABLE v16
EDB Postgres Advanced Server includes syntax not offered by Oracle with the
DROP QUEUE TABLE SQL command. You can use this syntax with
DROP QUEUE TABLE — Drop a queue table.
DROP QUEUE TABLE to delete a queue table:
DROP QUEUE TABLE allows a superuser or a user with the
aq_administrator_role privilege to delete a queue table.
The name (possibly schema-qualified) of the queue table to delete.
IF EXISTS clause if you don't want to return an error if the queue table doesn't exist. Instead, issue a notice.
CASCADE keyword to delete objects that depend on the queue table.
RESTRICT keyword to prevent deleting the queue table if any objects depend on it. This is the default.
This example deletes a queue table named
work_order_table and any objects that depend on it: