ALL_QUEUE_TABLES v11
The ALL_QUEUE_TABLES view provides information about all of the queue tables in the database.
| Name | Type | Description |
|---|---|---|
owner | TEXT | Role name of the owner of the queue table. |
queue_table | TEXT | The user-specified 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 order in which the queue table is sorted. |
recipients | CHARACTER VARYING | Always SINGLE. |
message_grouping | CHARACTER VARYING | Always NONE. |
compatible | CHARACTER VARYING | The release number of the Advanced Server release with which this queue table is compatible. |
primary_instance | NUMERIC | Always 0. |
secondary_instance | NUMERIC | Always 0. |
owner_instance | NUMERIC | The instance number of the instance that owns the queue table. |
user_comment | CHARACTER VARYING | The user comment provided when the table was created. |
secure | CHARACTER VARYING | YES indicates that the queue table is secure; NO indicates that it is not. |