检查表的某个列是否有索引

 

SQL> select index_owner,index_name,table_owner,table_name from dba_ind_columns where table_name='EMP';

INDEX_OWNER                    INDEX_NAME                     TABLE_OWNER                    TABLE_NAME
------------------------------ ------------------------------ ------------------------------ ------------------------------
SCOTT                          PK_EMP                         SCOTT                          EMP