To see the indexes for a table

To see the indexes for a table

SQL> select owner, table_name, index_name, column_name
FROM dba_ind_columns
Order by owner, table_name, column_position
Where owner=’SCOTT’
AND table_name=’EMP’;

TABLE_OWNER TABLE_NAME INDEX_NAME COLUMN_NAME
--------------- -------------------- -------------------- ----------
SCOTT EMP PK_EMP EMPNO

Sphere: Related Content