DROP QUEUE

DROP QUEUE

Syntax

drop_queue ::=

Prerequisites

Only the SYS user, the owner of the schema containing the queue, and users having the DROP ANY TABLE system privilege can execute the DROP QUEUE statement.

Description

This statement is used to delete the specified queue. The queue table, the index for the queue table and the sequence used to generate MSGID values in the queue table are deleted along with the queue.

Example

<Query> Delete the message queue Q1 and its associated objects.

iSQL> DROP QUEUE Q1;