You are here

CREATE VIEW

Syntax

Description:

    CREATE VIEW creates an speciel view on one or more sql-tables in the database in form of a new virtual (only in the memory created) table. In CREATE VIEW you can use accordingly to the database software only a part of the SELECT-Commands clauses.

    Example:

CREATE VIEW myorders (
  my_onum,
  my_anz ) AS
SELECT
 onum,
 anz
FROM torder
WHERE preis > 0;

Creates a view on the table 'torders', which contains inly the fields 'anum' und 'anz' from records with 'preis' > 0.