ALL_INDEXES view contains information about the indexes : all_indexes « System Tables Views « Oracle PL / SQL

1. Oracle PL / SQL
2. System Tables Views
3. all_indexes

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>

   
    
  

Related examples in the same category