The following table compares the capabilities of regular views, materialized views, and tables:
| Allows | Regular views | Materialized views | Tables |
|---|---|---|---|
| Access privileges | Yes | Yes | Yes |
| SELECT | Yes | Yes | Yes |
| UPDATE | Some | No | Yes |
| INSERT | Some | No | Yes |
| DELETE | Some | No | Yes |
| Dependent views | Yes | Yes | Yes |
| Indexes | No | Yes | Yes |
| Integrity constraints | No | No | Yes |
| Keys | No | No | Yes |
 |
Discuss this page in DocCommentXchange.
|
Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0 |