Oracle查询表字段信息及注释

查询表字段信息:

SELECT * FROM all_tab_columns WHERE OWNER = 'OWNER_NAME' AND TABLE_NAME='TABLE_NAME'
-- 或者
SELECT * FROM user_tab_columns WHERE TABLE_NAME='TABLE_NAME'

查询表字段注释信息:

SELECT * FROM all_col_comments WHERE TABLE_NAME='TABLE_NAME'
--或者
SELECT * FROM user_col_comments WHERE TABLE_NAME='TABLE_NAME'

posted @ 2022-05-11 14:55  流星小子  阅读(813)  评论(0编辑  收藏  举报