Toad World® Forums

SQL Server - computed column specification


#1

Hello,

In SQL Server 2005, you can specify that a column has a ‘Computer Column Specification’ what is a return value of a function.

Is there a way to set this up using Toad? I can not seem to find this capability.

Thanks.

Jeff


#2

Hi Jeff,

Please open the Attribute Properties dialog and fromthe Data Type box, select ‘Computed Column’.

When it is selected, you can specify Computed Column Expression and Persisted Computed Column.

If you have more questions, please write me back. Thanks.

Regards,

Vladka


#3

Hi Vladka,

That worked great. Thanks!

-Jeff