erwin schema generation option

* Oracle

Mode : Physical 

Database > Pre & Post Scripts > Model Level

1. Script Template 새로 생성 

2. Code 란에 아래 내용 삽입

 

%ForEachTable() { 

COMMENT ON TABLE %TableName IS '%EntityName'; 

%ForEachColumn() {  

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

} 

}

 

* MSSQL

%ForEachTable() 

{

exec sp_addextendedproperty 'MS_Description' , '%EntityName' , 'user' , 'dbo' , 'table' , '%TableName'

go

%ForEachColumn() 

{

exec sp_addextendedproperty 'MS_Description' , '%AttName' , 'user' , 'dbo' , 'table' , '%TableName' , 'column' , '%ColName'

go

}

}

 

 

참고 : Forward Engineer 에서 Schema Generation 할 때 첨부파일을 Option Set으로 설정

출처 : http://blog.naver.com/PostView.nhn?blogId=2zerox&logNo=90175801084&categoryNo=11&parentCategoryNo=0&viewDate=&currentPage=1&postListTopCurrentPage=&userTopListOpen=true&userTopListCount=5&userTopListManageOpen=false&userTopListCurrentPage=1