ALL_UNUSED_COL_TABS

ALL_UNUSED_COL_TABS describes all tables accessible to the current user that contain unused columns.

Related Views

• DBA_UNUSED_COL_TABS describes all tables in the database that contain unused columns.
• USER_UNUSED_COL_TABS describes all tables owned by the current user that contain unused columns. This view does not display the OWNER column.

  Column	Datatype	NULL	Description
  OWNER	VARCHAR2(30)	NOT NULL	The owner of the object
  TABLE_NAME	VARCHAR2(30)	NOT NULL	The name of the table
  COUNT	NUMBER		The number of unused columns