[SQL] 특정 DB owner가 생성한 테이블의 정보 가져오기
Oracle 기준 SELECT A.OWNER , A.TABLE_NAME , A.COMMENTS AS TABLE_COMM , B.COLUMN_ID , B.COLUMN_NAME , C.COMMENTS AS COLUMN_COMM , B.DATA_TYPE , B.DATA_LENGTH , B.DEFAULT_LENGTH , B.NULLABLE , B.DATA_DEFAULT FROM ALL_TAB_COMMENTS A LEFT OUTER JOIN ALL_TAB_COLUMNS B ON A.TABLE_NAME = B.TABLE_NAME LEFT OUTER JOIN ALL_COL_COMMENTS C ON B.TABLE_NAME = C.TABLE_NAME AND B.COLUMN_NAME = C.COLUMN_NAME WHERE..
2019. 9. 4.