USER_TABLES¶
USER_TABLES displays table information in the current schema.
Name | Type | Description |
|---|---|---|
owner | character varying(64) | Table owner |
table_name | character varying(64) | Table name |
tablespace_name | character varying(64) | Name of the tablespace that contains the table |
status | character varying(8) | Whether the current record is valid |
temporary | character(1) | Whether the table is a temporary table
|
dropped | character varying | Whether the current record is deleted
|
num_rows | numeric | The estimated number of rows in the table |