ALL_TABLES v17
The ALL_TABLES
view provides information on all user-defined tables.
Name | Type | Description |
---|---|---|
owner | TEXT | User name of the table’s owner. |
schema_name | TEXT | Name of the schema in which the table belongs. |
table_name | TEXT | Name of the table. |
tablespace_name | TEXT | Name of the tablespace in which the table resides. If the tablespace name isn't specified, the default tablespace PG_DEFAULT . |
degree | CHARACTER VARYING(10) | Number of threads per instance to scan a table, or DEFAULT . |
status | CHARACTER VARYING(5) | Whether or not the state of the table is valid. Included only for compatibility. Always set to VALID . |
temporary | CHARACTER(1) | Y if this is a temporary table, N if this isn't a temporary table. |