Blog Home  Home Feed your aggregator (RSS 2.0)  
The Johnnynine Weblog - March, 2006
A weblog by Johnny Hughes
 
 Thursday, March 16, 2006

Here is the sql to view the indexes on an oracle table.  Just replace MYTABLENAME with yout table name:

select index_name, column_name, column_position from user_ind_columns
where table_name='MYTABLENAME' order by index_name, column_position

Thursday, March 16, 2006 11:35:49 PM (US Mountain Standard Time, UTC-07:00)  #    Comments [1]   Database | Oracle | Technical  | 
Copyright © 2008 Johnny Hughes. All rights reserved.
DasBlog 'Portal' theme by Johnny Hughes.