Help Center > > Developer Guide> System Catalogs and System Views> System Views> USER_TABLES

USER_TABLES

Updated at: Jul 15, 2020 GMT+08:00

USER_TABLES displays table information in the current schema.

Table 1 USER_TABLES columns

Name

Type

Description

owner

character varying(64)

Table owner

table_name

character varying(64)

Table name

tablespace_name

character varying(64)

Tablespace name of a table

status

character varying(8)

Whether the current record is valid

  • Y indicates that it is a temporary table.
  • N indicates that it is not a temporary table.

temporary

character(1)

Whether the table is a temporary table

dropped

character varying

Whether the current record is deleted

  • YES indicates that it is deleted.
  • NO indicates that it is not deleted.

num_rows

numeric

The estimated number of rows in the table

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel