1, the lookup table for all indexes (including the index name, type, constitute a column):

select t. *, i.index_type from user_ind_columns t, user_indexes i where t.index_name = i.index_name and t.table_name = i.table_name and t.table_name = query table

2, the lookup table’s primary key (including name, constitute column):

select cu * FROM user_cons_columns the cu user_constraints au where cu.constraint_name = au.constraint_name and au.constraint_type = ‘P’ and au.table_name = table to query

3, the lookup table unique constraint (including name, constitute column):

select column_name from user_cons_columns cu, user_constraints au where cu.constraint_name = au.constraint_name and au.constraint_type = ‘U’ and au.table_name = table to query

4, the lookup table foreign key (including name, citing the name of the table and the corresponding key name, the following is divided into multi-step query):

select * from user_constraints c where c.constraint_type = ‘R’ and c.table_name = table to query

Discover the name of the foreign key constraint column:

select * from user_cons_columns cl where cl.constraint_name = foreign key name

Query reference table key column:

select * from user_cons_columns cl where cl.constraint_name = key name of the foreign key references the table

5, all the columns of the lookup table and its properties

select t. *, c.COMMENTS from user_tab_columns t, user_col_comments c where t.table_name = c.table_name and t.column_name = c.column_name and t.table_name = query table