oracle index 정보 추출

Oracle index

 

 SELECT ix.table_owner
       , ix.table_name
       , tc.comments
       , ic.index_name
       , ic.column_name
       , ic.column_position
       , ix.uniqueness
    FROM user_indexes ix
       , user_ind_columns ic
       , user_tab_comments tc
   WHERE ic.index_name = ix.index_name
     AND IC.TABLE_NAME = tc.table_name
     and  ic.index_name not like '%PK01'
     and ic.column_position = '1'
     and uniqueness ='UNIQUE'

 

 

 

 

-퍼옴
원본 : http://blog.naver.com/eureka6846/110124199290