ERD기준으로 테이블생성하기- ERWin

개발을 하다보면 당연히 접하게 되는 ERWin

ERWin에서 테이블을 생성하는 방법

- ERWin 실행

- Tools -> Forward Enginner -> Schema Generation 선택

- 생성할 것들만 체크 -> Preview

SELECT A.*

FROM   CONVDBA.TOBE_TABLE_MAP A

WHERE 1=1

AND    CONV_YN = 'Y'

AND    SUBSTR(E_TABLE_NAME_TOBE,1,1) IN ('A','M','S','G','C')

AND    EXISTS (SELECT 1

                   FROM (SELECT DISTINCT E_TABLE_NAME_TOBE

                            FROM   CONVDBA.TOBE_TABLE_MAP A

                                    , DBA_OBJECTS B

                            WHERE 1=1

                            AND    A.E_TABLE_NAME_TOBE = B.OBJECT_NAME(+)

                            AND    A.CONV_YN = 'Y'

                            AND    SUBSTR(A.E_TABLE_NAME_TOBE,1,1) IN ('A','M','S','G','C')

                            AND    B.OWNER(+) = 'CONVTOBE'

                            AND    B.OBJECT_TYPE(+) = 'TABLE'

                            AND    B.OBJECT_NAME IS NULL) B

                  WHERE  1=1

                  AND     A.E_TABLE_NAME_TOBE = B.E_TABLE_NAME_TOBE)

잊어버리면 안되니...체크 ㅎ