| sql-command ::= | CREATE [TEMP | TEMPORARY] VIEW view-name AS select-statement |
The CREATE VIEW command assigns a name to a pre-packaged SELECT statement. Once the view is created, it can be used in the FROM clause of another SELECT in place of a table name.
You cannot COPY, DELETE, INSERT or UPDATE a view. Views are read-only in eSQL. However, in many cases you can use a TRIGGER on the view to accomplish the same thing. Views are removed with the DROP VIEW command. Non-temporary views cannot be created on tables in an attached database.