Oracle查询备注信息

TABLE_NAME, TABLE_TYPE, COMMENTS FROM USER_TAB_COMMENTS WHERE TABLE_NAME = ‘MR_DEPT;

查询字段的备注信息：

SELECT
    TABLE_NAME,
    COLUMN_NAME,
    COMMENTS
FROM
    USER_COL_COMMENTS
WHERE
    TABLE_NAME = ‘SFA_STOCK_REQUEST‘

Oracle查询备注信息

标签：