ADM_TABLES

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