Today, i will share the query which will give the column names along with table name on which index is created.Below is the Query for the same.
select a.index_name,a.table_name,b.column_name from
and a.uniqueness=’UNIQUE’ and
a.table_name in <LLIST OF TABLE NAMES>
Query to give column names which are not null in the table.
where table_name like ‘%ABC%’
order by table_name