Updated on 2025-07-15 GMT+08:00

ADM_TABLES

ADM_TABLES displays information about all partitioned tables in the database. By default, only users with the SYSADMIN permission can access this view. Common users can access the view only after being authorized. This view exists in both PG_CATALOG and SYS schemas.

Table 1 ADM_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 the table.

dropped

character varying

Specifies whether the current table is deleted.

  • YES: It is deleted.
  • NO: It is not deleted.

num_rows

numeric

Estimated number of rows in the table.

status

character varying(8)

Specifies whether the current table is valid.

  • VALID: The current table is valid.
  • UNUSABLE: The current table is unavailable.

temporary

character(1)

Specifies whether the table is a temporary table.
  • Y: The table is a temporary table.
  • N: The table is not a temporary table.