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 |