如何在oracle中查询所有用户表的表名、主键名称、索引、外键等

--WORD 格式---可编辑--

--

1?￠ 2é ??±íμ

??ùó ??÷ ??￡¨°üà¨

?÷ ????￡ ?àà ?í￡ ?113éá ?￡ ?￡ o

select t.*,i.index_type from t.index_name = i.index_name

t.table_name =

ò a2é ?ˉμ ?±í

user_ind_columns

and t.table_name

t,user_indexes

= i.table_name

i

w here

and

2?￠ 2é ??±íμ ??÷ ?ü￡¨°üਠ??3?￡ ?113éá ?￡ ?￡ o

select cu.* from cu.constraint_name

user_cons_columns = au.constraint_name

cu, user_constraints

and au.constraint_type

au where

= 'P'

and au.table_name =

ò a2é ?ˉμ ?±í

3?￠ 2é ??±íμ

??¨ ??????ê ?￡¨°üà¨

??3?￡ ?113éá ?￡ ?￡ o

select column_name where cu.constraint_name

from

user_cons_columns = au.constraint_name

cu,

user_constraints

and au.constraint_type

au

= 'U' and au.table_name =

ò a2é ?ˉμ ?±í

4?￠ 2é ??±íμ ?í a?ü￡¨°üਠ??3?￡ ???ó ?±íμ ?±í ??o í ??ó | μ ??ü ??￡ ?????ê ?· ?3é ?à2 ?2é ?ˉ￡ ?￡ o

select * from user_constraints c where c.constraint_type = 'R' and c.table_name =

ò a2é ?ˉμ ?±í

2é ?ˉí a?ü ??ê ?μ ?á ???￡ o select

* from user_cons_columns

cl where cl.constraint_name

= í a?ü ??3?

2é ?ˉ ??ó ?±íμ ??üμ ?á ???￡ o select

*

from

user_cons_columns

cl

where

cl.constraint_name

=

í a?ü ??ó ?±íμ ??ü ??

5?￠ 2é ?ˉ±íμ ??ùó ?á ??° ??ê ??? select

t.*,https://www.360docs.net/doc/fc15691171.html,MENTS

from

user_tab_columns

t,user_col_comments

where t.table_name = c.table_name and t.column_name = c.column_name

and t.table_name =

ò a2é ?ˉμ ?±í

c