Thursday, August 21, 2008

DBA_UNUSED_COL_TABS

Oracle 11gR1

DBA_UNUSED_COL_TABS describes all tables in the database containing unused columns. Its columns are the same as those in ALL_UNUSED_COL_TABS.

Related Views

· ALL_UNUSED_COL_TABS describes the tables accessible to the current user 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 object

TABLE_NAME

VARCHAR2(30)

NOT NULL

Name of the table

COUNT

NUMBER

Number of unused columns

Oracle data dictionary views

No comments:

Post a Comment