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)
  • Y: specifies that the table is a temporary table.
  • N: specifies that the table is not a temporary table.