You can change the expression used in a computed column with the ALTER TABLE statement. The following statement changes the expression that a computed column is based on.
ALTER TABLE table-name ALTER column-name SET COMPUTE ( new-expression );
The column is recalculated when this statement is executed. If the new expression is invalid, the ALTER TABLE statement fails.
The following statement stops a column from being a computed column.
ALTER TABLE table-name ALTER column-name DROP COMPUTE;
Existing values in the column are not changed when this statement is executed, but they are no longer updated automatically.
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|