- 1.查询主键
select col.table_name,col.column_name from user_constraints con,user_cons_columns col where con.constraint_name=col.constraint_name and con.constraint_type='P' and col.table_name='<表名>'
- 2. 查询列
select * from user_tab_columns where table_name='EMP'
- 3查询视图
select * from user_views order by view_name
- 4查询表
select table_name from user_tables order by table_name