ERwin에서 Logical을 Comment로 생성하는 스크립트

Database -> Pre & Post Script -> Model-Level

Code 탭 -> New 버튼클릭 -> 스크립트 입력

:: Oracle

%ForEachTable() {
    COMMENT ON TABLE %TableName IS '%EntityName';

    %ForEachColumn() {
    COMMENT ON COLUMN %TableName.%ColName IS '%AttName';
    }
}

SQL

Copy

:: MySQL

%ForEachTable() {
    ALTER TABLE %TableName COMMENT = '%EntityName';

    %ForEachColumn() {
    ALTER TABLE %TableName CHANGE COLUMN %ColName %ColName %AttDatatype %AttNullOption COMMENT '%AttName';
    }
}

SQL

Copy

Forward Engineer Schema Generation -> Option 탭 -> Schema -> Post-Script 선택하여 체크

출처 : http://koreantramp.tistory.com/198