select table_name,constraint_name,constraint_type from user_constraints
where table_name='大寫的表名'
select table_name,constraint_name,constraint_type from dba_constraints
where table_name='大寫的表名'
---------另外以下可以只查看表中的索引
select * from USER_INDEXES where table_name = '大寫的表名'
下邊的也可以
select * from ALL_INDEXes where table_name = '大寫的表名'