Modifies a queue table.

Syntax

You can use the following syntax to modify the name of a queue table:

ALTER QUEUE TABLE name RENAME TO new_name

Description

You can use the ALTER QUEUE TABLE command to modify a queue table if you are a superuser or a user who has the aq_administrator_role privilege.

Parameters

ParameterDescription
Parameter Description
name The name of the queue table. The name can be schema-qualified.
new_name The new name of the queue table.

Example

Change the name of a queue table from wo_table_east to work_order_table:

ALTER QUEUE TABLE wo_queue_east RENAME TO work_order_table;