The ALL_TABLES view provides the information on all user-defined tables.
Parameter | Type | Description |
---|---|---|
owner | TEXT | The username of the owner to which the table belongs. |
schema_name | TEXT | The name of the schema to which the table belongs. |
table_name | TEXT | The name of the table. |
tablespace_name | TEXT | The name of the tablespace where the table is located if this tablespace is not the default tablespace. |
status | CHARACTER VARYING(5) | Indicates that whether the status of the table is valid. This parameter is supported for compatibility only. The value is VALID. |
temporary | CHARACTER(1) |
|