DBA_TABLES v17

The DBA_TABLES view provides information about all tables in the database.

NameTypeDescription
ownerTEXTUser name of the table owner.
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 the tablespace name isn't specified, the default tablespace is PG_DEFAULT.
degreeCHARACTER VARYING(10)Number of threads per instance to scan a table, or DEFAULT.
statusCHARACTER VARYING(5)Included only for compatibility. Always set to VALID.
temporaryCHARACTER(1)Y if the table is temporary. N if the table is permanent.