[SQL] 테이블명, 컬럼명, PK를 조회할수 있는 쿼리
DB : Oarcle SELECT A.TABLE_NAME as 테이블명 , B.COMMENTS as 테이블한글명 , A.COLUMN_NAME as 컬럼명 , C.COMMENTS as 컬럼한글명 , A.DATA_LENGTH , A.DATA_TYPE , A.NULLABLE , D.CONSTRAINT_NAME , D.CONSTRAINT_TYPE FROM ALL_TAB_COLUMNS A , ALL_TAB_COMMENTS B , ALL_COL_COMMENTS C , ALL_CONSTRAINTS D WHERE A.TABLE_NAME = B.TABLE_NAME AND A.TABLE_NAME= C.TABLE_NAME AND A.TABLE_NAME= D.TABLE_NAME AND A.COLUMN_NAME= C.COLUM..
2011. 9. 1.