Syntax

CREATE VIEW Viewname
[ ( fieldname [,...] ) ] AS
SELECT-Command ;

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.

Syntax

DROP VIEW Viewname;

Description

DROP VIEW deletes an in the database stored view.

Example:

DROP VIEW myorders;

Here is the view 'myorders' deleted from the database.