1 查询表名,表注释,表记录
SELECT
T .TABLE_NAME,
c.comments,
T .NUM_ROWS
FROM
USER_TABLES T
LEFT JOIN user_tab_comments c ON T .TABLE_NAME = c.table_name;
2 查询表名、表注释、字段名、字段注释
SELECT
T.TABLE_NAME,
c.comments tableComments,
cc.column_name,
cc.comments colComments
FROM
USER_TABLES T
LEFT JOIN user_tab_comments c ON T .TABLE_NAME = c.table_name
LEFT JOIN user_col_comments cc ON T .TABLE_NAME = cc.table_name