Showing posts with label Index. Show all posts
Showing posts with label Index. Show all posts

Friday, April 25, 2014

Oracle : How to find all indexes under certain table.

How to find all indexes under certain table.

select index_name, column_name
 from user_ind_columns
 where table_name = '<table_name>';