ADM_TABLES

YES: The record is deleted.
NO: The record is not deleted.

ADM_TABLES displays all tables in the database. By default, only the system administrator can access this view. Common users can access the view only after being authorized. This view exists in both PG_CATALOG and SYS schema.

**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	Whether the current record is deleted YES: The record is deleted. NO: The record is not deleted.
num_rows	numeric	Estimated number of rows in the table
status	character varying(8)	Whether the current record is valid
temporary	character(1)	Whether the table is a temporary table Y: The table is a temporary table. N: The table is not a temporary table.