The USER_TABLES view provides the information about all tables owned by the current user.
Parameter | Type | Description |
---|---|---|
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 to which the table belongs if this tablespace is not the default tablespace. |
status | CHARACTER VARYING(5) | This parameter is supported for compatibility only. The value is VALID. |
temporary | CHARACTER(1) |
|