ALL_ALL_TABLES v17
The ALL_ALL_TABLES view provides information about the tables the current user can access.
| Name | Type | Description |
|---|---|---|
owner | TEXT | User name of the table’s owner. |
schema_name | TEXT | Name of the schema in which the table belongs. |
table_name | TEXT | Name of the table. |
tablespace_name | TEXT | Name of the tablespace in which the table resides. If the tablespace name isn't specified, then default tablespace PG_DEFAULT. |
degree | CHARACTER VARYING(10) | Number of threads per instance to scan a table, or DEFAULT. |
status | CHARACTER VARYING (5) | Included only for compatibility. Always set to VALID. |
temporary | TEXT | Y if the table is temporary, N if the table is permanent. |