Computed columns in Visio

B

baruchl

Hello.
I'm using Visio 2005 for Enterprise Arhitects edition, and it seems
like the DB model doesn't support computed columns. I tried to create
such columns in the DB and then reverse engineer it to the Visio, but
Visio "cleverly" removes the computed column code and leave it as a
regualr code.

for example, in the DB I wrote:
create table SNG_TTR_RESULT (
RUN_ID uniqueidentifier not null,
ANALYSIS_TYPE AS CAST('TTR' AS VARCHAR(50)) PERSISTED NOT NULL)

go

and after reverse engineering in Visio and code creation, I get this:
create table SNG_TTR_RESULT (
RUN_ID uniqueidentifier not null,
ANALYSIS_TYPE VARCHAR(50) NOT NULL)
go

Do you know how can I create a computed column in Visio? Failing to do
so will break synchronization between Visio and the DB which will force
me to stop using Visio :( ...

Thanks,
Busi
 
Top