Computed Column - MS SQL

[Chris Mecum]

How is a computed column represented in a database (class) diagram? When reverse engineering from MS SQL, EA does not pick up the column's formula.

I have seen some articles that use a Note linked to the attribute, with the computation in the Note, but this has no special meaning to UML and does not produce the required DDL script.

Thank you.

[Geert Bellekens]

Chris,

From a UML point of view that would be a derived attribute, probably with the derivation formula in a constraint on this attribute.

But I have no clue as to how EA treats this (it probably ignores it completely) with regards to ddl generation.

Geert

[Chris Mecum]

Thanks, Geert. That gives me something to go on.

If a class element is stereotyped as "table" it does not allow the attributes to be flagged as derived. I'll have to figure out something on that. It also looks like the DDL generation can't be changed like the code generation templates.

[Geert Bellekens]

Thanks, Geert. That gives me something to go on.

If a class element is stereotyped as "table" it does not allow the attributes to be flagged as derived. I'll have to figure out something on that. It also looks like the DDL generation can't be changed like the code generation templates.

bummer

Geert