表注释表:USER_TAB_COMMENTS
字段注释表:USER_COL_COMMENTS
表名字段名:TABLE_NAME
表字段字段名:COLUMN_NAME
表注释字段名:COMMENTS
查询当前用户的所有表
SELECT TABLE_NAME FROM USER_TABLES;
根据数据库表名查询表备注
SELECT
TABLE_NAME,
COMMENTS
FROM
USER_TAB_COMMENTS
WHERE
TABLE_NAME = '表名'
ORDER BY TABLE_NAME;
根据数据库表名查询表字段
SELECT
COLUMN_NAME
FROM
USER_TAB_COLUMNS
WHERE
TABLE_NAME='表名'
ORDER BY COLUMN_NAME;
根据数据库表名查询表字段备注
SELECT
COLUMN_NAME,
COMMENTS
FROM
USER_COL_COMMENTS
WHERE
TABLE_NAME = '表名'
ORDER BY COLUMN_NAME;
根据数据库表名查询其外键关联表
SELECTTABLE_NAME
FROM
USER_CONSTRAINTS C
WHERE
R_CONSTRAINT_NAME = '表主键';