USER_ALL_TABLES v11
The USER_ALL_TABLES view provides information about all tables owned by the current user.
| Name | Type | Description |
|---|---|---|
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 other than the default tablespace. |
status | CHARACTER VARYING(5) | Included for compatibility only; always set to VALID. |
temporary | TEXT | Y if the table is temporary; N if the table is permanent. |