Computed Columns and Alter Table

[seekwall]

Could any one who is mad enough to be working today please tell me how I can convert an existing column within a table to a computed column (sum of several other columns), without dropping and adding the column again ?

 

[tlbroadbent]

Paul,

Your request isn't logical. Computed columns are virtual columns, not physically stored on the table. If you are replacing a physical column with a computed column, you must drop the original column and add the computed column. In other words, you drop a physical entity and replace it with a virtual entity. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.