Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

ALL_IND_COLUMNS view contains information about the columns indexed by an index on a table

SQL> SQL> select table_name, column_name from  all_ind_columns   2  where index_name = 'COUNTRY_C_ID_PK'; TABLE_NAME ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COUNTRIES COUNTRY_ID SQL>