검색결과 리스트
스키마에 해당되는 글 1건
- 2011.04.06 [오라클] 테이블 스키마 가져오기
글
-- DB 테이블 스키마 가져오기.
SELECT B.COLUMN_NAME AS 컬럼명
, B.DATA_TYPE AS 테이터타입,
B.DATA_LENGTH AS 길이,
B.NULLABLE AS NULL구분,
B.COLUMN_ID AS 컬럼순서,
A.COMMENTS AS 설명
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 '테이블명'
ORDER BY B.COLUMN_ID;
SELECT B.COLUMN_NAME AS 컬럼명
, B.DATA_TYPE AS 테이터타입,
B.DATA_LENGTH AS 길이,
B.NULLABLE AS NULL구분,
B.COLUMN_ID AS 컬럼순서,
A.COMMENTS AS 설명
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 '테이블명'
ORDER BY B.COLUMN_ID;
RECENT COMMENT