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
all_indexes a,
all_ind_columns b
where a.table_name=b.table_name
and a.index_name=b.index_name
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.

select table_name,column_name

from all_tab_columns

where table_name like ‘%ABC%’

and NULLABLE=’N’

and owner=<SCHEMA_NAME>

order by table_name

Leave a Reply

Your email address will not be published. Required fields are marked *