[Oracle]察看一张表的约束 和 察看一张表的索引

--察看一张表的约束
select table_name,constraint_name,constraint_type from user_constraints where table_name=upper('your_table')

select table_name,constraint_name,constraint_type from dba_constraints where table_name=upper('your_table') 

--察看一张表的索引
select * from USER_INDEXES where table_name = upper('your_table')

select * from ALL_INDEXes where table_name = upper('your_table')

--END-- 2019-11-01 12;21