查询数据库表、表字段、主键、字段注释等，oracle

-- 查询表
select * from all_tables where owner='MO_FORM_V5';
select table_name from user_tables;

-- 查询表注释
select * from user_tab_comments where table_name='FORM_DATASOURCE';

-- 查询表字段
select * from cols where table_name=upper('form_datasource');

select * from user_tab_columns where table_name=upper('form_datasource');
-- 主键
select cu.* from user_cons_columns cu, user_constraints au where cu.constraint_name = au.constraint_name and au.constraint_type = 'P' and au.table_name =upper('form_datasource');

-- 字段注释
select * from user_col_comments where table_name='FORM_DATASOURCE';