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 |
 |
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |