Start a new topic

Script computed column in DDL

[This topic is migrated from our old forums. The original author name has been removed]

Currently, the DDL view for tables containing computed columns (in SQL Server), do not show the column expression - only the data type.

[This reply is migrated from our old forums.]

Re: Script computed column in DDL
Hi Matt, I've registered a ticket for this. Best Regards, Hans
[This reply is migrated from our old forums.]

Re: Script computed column in DDL
Hi Matt, This will be partly solved in the next feature release, meaning that instead of seeing the data type for the computed expression in the DDL you will see the actual computed expression, e.g. "(([FirstName]+space((1)))+[LastName])". A limitation is that the column expression cannot be declared or altered for a column via the Create Table and Alter Table dialogs. To fully support computed expressions in these dialogs requires changes similar to what is needed to support user-defined types, which currently has low priority. I hope getting more accurate DDL helps a bit at least. Best Regards, Hans
[This reply is migrated from our old forums.]

Re: Script computed column in DDL
Hi, Just to inform that this is now fixed in the latest DbVisualizer 8.0 version. Regards Roger