I have stored computed column defined as:
ALTER TABLE computed_column AS INT col1+col2 STORED;
Is there way to change the calculation to col1+col3 without first dropping the computed_column?
I have stored computed column defined as:
ALTER TABLE computed_column AS INT col1+col2 STORED;
Is there way to change the calculation to col1+col3 without first dropping the computed_column?
No, unfortunately there is no way to change the expression of a computed column at this time.