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

SQL Anywhere 11.0.0 » SQL Anywhere Server - SQL Usage » Designing and Creating Databases » Working with database objects » Working with tables » Working with computed columns


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.

Computed columns are recalculated under the following circumstances:

  • Any column is deleted, added, or renamed.
  • The table is renamed.
  • Any column's data type or COMPUTE clause is modified.
  • A row is inserted.
  • A row is updated.

Computed columns are not recalculated under the following circumstances:

  • The computed column is queried.
  • Values are changed in columns on which the computed column depends.