Modifying the computed column

• MuraliKrishnan1980

  SSCrazy

  Points: 2497

  More actions

  September 14, 2011 at 12:15 am

  #243688

  Hello Friends,

  I have defined a column as computed column by mistake and due to this i am unable to do the update operation on this column. Is there a way to alter this column and mark it as a normal column.

  Your response would be appreciated.

  Thanks

  Murali

• HowardW

  One Orange Chip

  Points: 29109

  More actions

  September 14, 2011 at 4:18 am

  #1381149

  Nope. You have to drop and recreate it (same if you want to change the definition of a computed column).

  If you need to maintain the column order (which you shouldn't as it's meaningless) you would need to recreate the table and migrate data.