Obsidian/Recognition/Programing/Tibero/특정 컬럼 코멘트 확인(Sort).md

243 B


-- 특정 테이블 컬럼 코멘트
SELECT b.column_name, b.comments
FROM ALL_TAB_COLS a, ALL_COL_COMMENTS b
WHERE a.table_name = b.table_name
AND a.column_name = b.column_name
AND a.table_name = 'IIS_AFSARR'
ORDER BY a.column_id