USER_TABLES v12

The USER_TABLES view displays information about all tables owned by the current user.

NameTypeDescription
schema_nameTEXTName of the schema in which the table belongs.
table_nameTEXTName of the table.
tablespace_nameTEXTName of the tablespace in which the table resides if other than the default tablespace.
statusCHARACTER VARYING(5)Included for compatibility only; always set to VALID.
temporaryCHARACTER(1)Y if the table is temporary; N if the table is not temporary.