查看oracle中的表的字段类型的sql:
select COLUMN_NAME,DATE_TYPE,DATA_LENGTH,DATA_PRECISION from all_tab_columns
where table_name = '表名(最好大写)' order by COLUMN_ID
查看oracle字段注释:sql
select COLUMN_NAME,comments,DATA_TYPE,DATA_LENGTH from user_tab_columns where table_name = '表名';
查看mysql 或者 hive的表字段注释:
show create table "表名"