Oracle 查看表字段的注释 原创

Oracle 查看表字段的注释

复制收展SQLselect tc.COLUMN_NAME, cc.comments
from user_tab_columns tc
left join user_col_comments cc on cc.table_name = tc.TABLE_NAME and cc.column_name = tc.COLUMN_NAME
where tc.Table_Name = '你的表名'
order by tc.COLUMN_ID;
1
2
3
4
5