../E40402-16.epub /> ../E40402-16.mobi />

ALL_UNUSED_COL_TABS

ALL_UNUSED_COL_TABS describes the 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 the 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 Owner of the table
TABLE_NAME VARCHAR2(30) NOT NULL Name of the table
COUNT NUMBER   Number of unused columns