1. Database -> Pre & Post Scripts -> Model-Level


2. code 스크립트 추가

//mysql

%ForEachTable() {

 ALTER TABLE %TableName COMMENT = '%EntityName' ENGINE=MyISAM DEFAULT CHARSET=utf8;

 %ForEachColumn() {

 ALTER TABLE %TableName CHANGE COLUMN %ColName %ColName %AttDatatype %AttNullOption COMMENT '%AttName';

 }

}


//oracle

%ForEachTable() {

 COMMENT ON TABLE %TableName IS '%EntityName';

 %ForEachColumn() {

 COMMENT ON COLUMN %TableName.%ColName IS '%AttName';

 }

}


//mssql

%ForEachTable() {

 ALTER TABLE %TableName COMMENT = '%EntityName' ENGINE=MyISAM DEFAULT CHARSET=utf8;

 %ForEachColumn() {

%IF(%==(%Substr(%ColumnNullOption,1,8)IDENTITY)){%=(NullOption,AUTO_INCREMENT)} %Else {%=(NullOption,%ColumnNullOption)}

 ALTER TABLE %TableName CHANGE COLUMN %ColName %ColName %AttDatatype %:NullOption COMMENT '%AttName';

 }

}


3. Tools -> Forward Engineer -> Schema Generation

Schema -> Post-Script check

Table -> Post-Script check


끝...



'MSSQL' 카테고리의 다른 글

테이블정의서 쿼리  (0) 2016.12.28
오늘이 해당 월에 몇주차 인지알아오기  (0) 2015.05.27
답변형 댓글 로직  (0) 2015.05.20
Posted by 따랑
,