Oracle PL/SQL/System Tables Views/all indexes

ALL_INDEXES view contains information about the indexes

   <source lang="sql">
 

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>

 </source>