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

USER_TABLES

Updated at: Sep 17, 2021 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)

Name of the tablespace where the table is located

status

character varying(8)

Whether the current record is valid

temporary

character(1)

Whether the table is a temporary table

  • Y: temporary table
  • N: not a temporary table

dropped

character varying

Whether the current record is deleted

  • YES: deleted
  • NO: not deleted

num_rows

numeric

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