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

SQL Anywhere 11.0.1 » SQL Anywhere Server - SQL Usage » Creating Databases » Working with database objects » Working with views


Comparing regular views, materialized views, and base tables

The following table compares regular views, materialized views, and base tables:

Capability Regular views Materialized views Base tables
Allow access permissions Yes Yes Yes
Allow SELECT Yes Yes Yes
Allow UPDATE Some No Yes
Allow INSERT Some No Yes
Allow DELETE Some No Yes
Allow dependent views Yes Yes Yes
Allow indexes No Yes Yes
Allow integrity constraints No No Yes
Allow keys No No Yes