A view is a computed table that is defined by the result set of its view definition, which is expressed as a SQL query. You can use views to show database users exactly the information you want to present, in a format you can control. SQL Anywhere supports two types of views: regular views and materialized views.

The definition for each view in the database is stored in the ISYSVIEW system table.

 See also