SELECT * FROM user_indexesWHERE table_name=YOUR_TABLE_NAME AND uniqueness='UNIQUE';select t.*,i.index_type from user_ind_columns t,user_indexes i where t.index_name = i.index_name and i.uniqueness='UNIQUE' and t.table_name='NODE'