Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Usage » Working with Database Objects » Working with tables » Working with computed columns

Inserting and updating computed columns Next Page

Recalculating computed columns

Values of computed columns are automatically maintained by the database server as rows are inserted and updated. Most applications should never need to update or insert computed column values directly; however, since computed columns are base columns like any other, they can be directly referenced in predicates and in expressions when it makes sense to do so.

Computed columns are not recalculated when queried. Instead, computed columns are recalculated under the following circumstances:

If you use a time-dependent expression, or one that depends on the state of the database in some other way, then the computed column can not give a proper result.