MY_TABLES
MY_TABLES displays information about the tables owned by the current user. This view exists in both PG_CATALOG and SYS schemas.
Name |
Type |
Description |
---|---|---|
owner |
character varying(64) |
Table owner. |
table_name |
character varying(64) |
Table name. |
tablespace_name |
character varying(64) |
Tablespace name of the table. |
dropped |
character varying |
Specifies whether the current record is deleted.
|
num_rows |
numeric |
Estimated number of rows in the table. |
status |
character varying(8) |
Specifies whether the current record is valid.
|
temporary |
character(1) |
Specifies whether the table is a temporary table.
|
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot