Change or remove the expression used in a computed column.
You must have DBA authority, or be the owner of the table, or have permissions to alter the table.
Context and remarks
Connect to the database.
Execute an ALTER TABLE statement similar to the following to change the expression used for a computed column:
ALTER TABLE table-name ALTER column-name SET COMPUTE ( new-expression );
To convert a column to a regular (non-computed) column, execute an ALTER TABLE statement similar to the following:
ALTER TABLE table-name ALTER column-name DROP COMPUTE;
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|