oracle 怎么查询唯一索引

2025-06-21 15:52:14
推荐回答(1个)
回答1:

SELECT * FROM user_indexes
WHERE 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'