SQL Guide : solidDB® SQL statements : CREATE VIEW
  
CREATE VIEW
CREATE VIEW viewed_table_name [( column_identifier
   [,column_identifier ]... )]
AS query-specification
Usage
The CREATE VIEW statement creates a view. A view is like a virtual table that provides a different 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. All views 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;
Related reference
See also
solidDB® SQL statements