How to change DDL generation for MS SQL Server

[Steve Remington]

Hi All,

I have been using EA at what can be best described as a novice level for a little while. I do know EA has many customisation features that I am not yet using and I am about to dip my toe in the waters.

The first small customisation task I'd like to try is changing the content and format of the output of the DDL generated for MS SQL Server.

There are two things I'd like to change:

1) Display the attribute alias ("attAlias"?) value as the column comment rather than the attribute note as a comment in the DDL
2) Add attribute alias (and possible some attribute tagged values) as a column "ExtendedProperty".

I have looked high and low to find the script, macro or template that generates the DDL and in all of the place I have looked I cannot see where items like the ExtendedProperty are created and attribute notes are included in the DDL.

For the record I have looked at the source code engineering templates, MDA transformation templates, help, etc.

I would appreciate if a more experienced EA user could show me where in EA I make these changes and point me in the direction of any references that will guide me. I'm sure once I am looking it the correct place I will be able to make the changes I want to make.

Thanks in advance to all who reply.

Steve