Table size and Computed Columns

[GJK]

In SQL Sever, do the size of computed columns gets added to the total
size of the tables? Does SQL server stores the actual values in
computed columns?

Thanks
_GJK

[Hugo Kornelis]

On 8 Apr 2005 11:59:21 -0700, GJK wrote:

In SQL Sever, do the size of computed columns gets added to the total
size of the tables? Does SQL server stores the actual values in
computed columns?

Hi GJK,

Computed columns are not stored and don't add to the size of the tables,
unless you include them in a PRIMARY KEY or UNIQUE constraint.

Best, Hugo
--

(Remove _NO_ and _SPAM_ to get my e-mail address)