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>';

No comments:

Post a Comment