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

DBA_TABLES

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

DBA_TABLES displays all tables in the database. It is accessible only to users with system administrator rights.

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