The ALL_QUEUE_TABLES view provides information about all queue tables in the database.
| Parameter | Type | Description |
| owner | TEXT | The role name of the queue table owner. |
| queue_table | TEXT | The user-defined name of the queue table. |
| type | CHARACTER VARYING | The type of data stored in the queue table. |
| object_type | TEXT | The user-defined payload type. |
| sort_order | CHARACTER VARYING | The sort order of the queue table. |
| recipients | CHARACTER VARYING | The recipient type. The value is SINGLE. |
| message_grouping | CHARACTER VARYING | The message grouping mode. The value is NONE. |
| compatible | CHARACTER VARYING | The release number of PolarDB for PostgreSQL (Compatible with Oracle) that the queue table is compatible with. |
| primary_instance | NUMERIC | The primary instance number. The value is 0. |
| secondary_instance | NUMERIC | The secondary instance number. The value is 0. |
| owner_instance | NUMERIC | The instance number of the instance that owns the queue table. |
| user_comment | CHARACTER VARYING | The comment added when the queue table was created. |
| secure | CHARACTER VARYING | Specifies whether the queue table is secure. Valid values: YES | NO. |