oracle查询所有cdb名,oracle查询表信息（索引，外键，列等）

查看索引个数和类别

select * from user_indexes where table_name&＃61;&＃39;表名&＃39; ;

查看索引被索引的字段

SQL>select * from user_ind_columns where index_name&＃61;upper(&＃39;&index_name&＃39;);

PS:

查看某表的约束条件

SQL>select constraint_name, constraint_type,search_condition, r_constraint_name

from user_constraints where table_name &＃61; upper(&＃39;&table_name&＃39;);

SQL>select c.constraint_name,c.constraint_type,cc.column_name

from user_constraints c,user_cons_columns cc

where c.owner &＃61; upper(&＃39;&table_owner&＃39;) and c.table_name &＃61; upper(&＃39;&table_name&＃39;)

and c.owner &＃61; cc.owner and c.constraint_name &＃61; cc.constraint_name

order by cc.position;

查看视图的名称

SQL>select view_name from user_views;