Help Center/
GaussDB(DWS)/
Standard Data Warehouse (9.1.0.x)/
GaussDB(DWS) System Catalogs and Views/
System Views/
USER_TABLES
Updated on 2024-09-30 GMT+08:00
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 |
Estimated number of rows in the table |
Parent topic: System Views
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
The system is busy. Please try again later.
