erwin 이용 테이블 생성 주석포함 스크립트

Physical 모드로 설정후 Database > Pre&Post Script > Model-Level > Code

 

 

%ForEachTable(){
    exec sp_addextendedproperty 'MS_Description','%EntityName','user','dbo','table',    '%TableName'
    go

    %ForEachColumn(){
        exec sp_addextendproperty 'MS_Description','%AttName','user','dbo','table','%TableName','column','%ColName'
    go
    }

    COMMENT on TABLE %TableName IS '%EntityName';

    %ForEachColumn(){
        COMMENT on COLUMN %TableName.%ColName is           '%AttName';
    }

}

 

 

Tools > Forward Engineer > Schema Generation > Post Scritpt > Report 버튼 클릭