DataBase/Oracle
테이블 스키마 내용 알아보는 쿼리문
탑~!
2012. 7. 13. 15:45
SELECT B.COLUMN_NAME
, B.DATA_TYPE,
B.DATA_LENGTH,
B.NULLABLE ,
B.COLUMN_ID,
A.COMMENTS
FROM USER_COL_COMMENTS A, USER_TAB_COLUMNS B
WHERE B.TABLE_NAME = A.TABLE_NAME
AND B.COLUMN_NAME = A.COLUMN_NAME
AND B.TABLE_NAME LIKE 'TIT_OBJECT_MST'
ORDER BY B.COLUMN_ID;
728x90
반응형