Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

ALL_INDEXES view contains information about the indexes

SQL> SQL> select table_name, index_name, uniqueness from all_indexes   2  where table_name = 'COUNTRIES'; TABLE_NAME                     INDEX_NAME                     UNIQUENES ------------------------------ ------------------------------ --------- COUNTRIES                      COUNTRY_C_ID_PK                UNIQUE SQL> SQL>