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

ALL_TABLES

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

ALL_TABLES displays all the tables accessible to the current user.

Table 1 ALL_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

temporary

character(1)

Whether the table is a temporary table

  • Y indicates that it is a temporary table.
  • N indicates that it is not 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