1、表基本信息(Table)
select * from user_tables t, user_tab_comments c
where c.table_name = t.table_name
and t.table_name = 'YOUR_TAB_NAME'
2、表的列信息(Column)
select * 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 = 'YOUR_TAB_NAME'
order by t.column_id
3、表的主键信息(Primary Key)
select * from user_cons_columns ucc, user_constraints uc
where uc.constraint_type='P'
and ucc.table_name = 'YOUR_TAB_NAME'
and ucc.constraint_name = uc.constraint_name
CONSTRAINT_TYPE 列的值及含义
4、索引(Index)
select * from user_ind_columns c, user_indexes i
where c.table_name = 'YOUR_TAB_NAME'
and c.index_name = i.index_name
and c.table_name = i.table_name
注:查询条件的参数 [YOUR_TAB_NAME] 需要大写。