Oracle 查询表名、表注释、字段名、字段类型、字段默认值、字段备注 发表于 2021-02-22 | 阅读次数: 查询表名和注释 123456select ut.table_name as "表名", utc.comments as "表注释"from user_tables ut LEFT OUTER JOIN user_tab_comments utc ON ut.table_name = utc.table_namewhere 1 = 1 and ut.table_name like ('%' || 'XX 表' || '%')order by ut.table_name asc; 查询表的字段信息 1234567891011select utc.column_name as "字段名", utc.data_default as column_default as "默认值", utc.nullable as "是否可为空", utc.data_type as "类型", utc.data_length as "长度", utc.column_id as "序号", acc.comments as "备注"from user_tab_columns utc left outer join all_col_comments acc on utc.table_name = acc.table_name and utc.column_name = acc.column_namewhere utc.table_name = 'XX 表'order by utc.column_id asc; 本文链接: https://zhangzw.com/posts/20210222.html 版权声明: 本博客所有文章除特别声明外,均采用 BY-NC-ND 许可协议。转载请注明出处!