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 |
 |
Discuter à propos de cette page dans DocCommentXchange.
|
Copyright © 2013, SAP AG ou société affiliée SAP - SAP Sybase SQL Anywhere 16.0 |