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. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |