H_Develop

-- 테이블정보 SELECT A.CLASS_NAME AS 테이블명, A.COMMENT AS [한글테이블명], B.ATTR_NAME AS 컬럼영문명, B.COMMENT AS 한글컬럼명, B.IS_NULLABLE AS [NULL여부], B.DATA_TYPE AS 데이터타입, B.PREC AS 데이터길이, CASE WHEN D.KEY_ATTR_NAME IS NOT NULL THEN 'Y' END AS PK정보, CASE WHEN F.KEY_ATTR_NAME IS NOT NULL THEN 'Y' END AS FK정보, B.DEFAULT_VALUE AS 제약조건, B.DEF_ORDER + 1 AS 컬럼순서 FROM DB_CLASS A INNER JOIN DB_ATTRIBUTE B ON B.CLASS_NAME = ..

DataBase/CUBRID 2023. 4. 24. 14:28