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

 

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

转载于:https://www.cnblogs.com/iyoume2008/p/4690660.html