EA软件修改数据库导出DDL模板实现将别名作为数据库字段注释

参考资料：模板|中的 DDL 选项企业架构师用户指南 (sparxsystems.com)https://sparxsystems.com/enterprise_architect_user_guide/15.2/model_domains/ddl_gen_options_in_templates.html

本文以mysql为例

包->数据库工程->编辑DDL模板

 修改数据库字段使用别名选择Mysql->DDL Column Comment

%if ddlOptionCommentLevel != "Column" and ddlOptionCommentLevel != "All"%
%endTemplate%

$columnComment = %ddlColumnComment%
%if $columnComment==""%
	$columnComment = %ddlColumnAlias%
%endIf%
%if $columnComment!=""%
COMMENT '%REPLACE($columnComment, "'", "''")%'
%endIf%

%if ddlOptionCommentLevel != "Table" and ddlOptionCommentLevel != "Column" and ddlOptionCommentLevel != "All"%
%endTemplate%

$tableComment=%ddlTableLevelComment%

%if $tableComment==""%
	$tableComment = %ddlTableAlias%
%endIf%

%if $tableComment != ""%
COMMENT='%REPLACE($tableComment, "'", "''")%'
%endIf%

如发现修改后不起作用确认此处是否一致：