Database Reference
In-Depth Information
•
Data modification (insert, update, and delete operations) can be
applied through views in the normal (SQL) manner, providing
that the view is updateable (more on this later). The view
statements are compiled or translated (depending on the DBMS),
and the implied base relations are updated at execution time.
•
Views can also be queried in a manner that is identical to how
base relations are queried.
13.1.1 View Creation
An abridged version of the
Create-View
statement appears in Figure
13-1
; the full syntax
is shown in Figure
13-2
.
Figure 13-1.
Abridged Form of Create-View Statement
Figure 13-2.
The Create-View Statement