Use 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.
Include the IF EXISTS
clause to instruct the server to not return an error if the queue table does not exist. The server will issue a notice.
Include the CASCADE
to automatically delete any objects that depend on the queue table.
Include the RESTRICT
to instruct the server to refuse to delete the queue table if any objects depend on it. This is the default.