solidDB Help : solidDB reference : SQL: Statements : CREATE VIEW
  
CREATE VIEW
CREATE VIEW table‑name [(column‑identifier [,column‑identifier …])]
   AS query‑specification
where:
query‑specification::= see query‑specification
Access requirements
Database user
Usage
Use the CREATE VIEW statement to create a virtual table that provides an alternative way of looking at the data in one or more tables; views are named specifications of a result table.
The specification is a SELECT statement that is run whenever the view is referenced in an SQL statement. A view has columns and rows just like a table and can be used just like tables for data retrieval.
Example
CREATE VIEW TEST_VIEW
    (VIEW_I, VIEW_C, VIEW_ID)
    AS SELECT I, C, ID FROM TEST;
Go up to
SQL: Statements