4. Maintaining a Distributed Database : Create Statement : Create View Syntax
 
Share this page                  
Create View Syntax
The create view statement has the following format:
create view view_name
       [(col_name {,col_name})] as subselect
view
Refers to the object identifier. This must be specified.
view_name
Defines the name of the view in the distributed database. It can be delimited with double quotes. This is an Ingres Star-level object as opposed to an object in a local database. The definition of this view is entered into the Ingres Star catalogs. The view can reference other tables and views.
For a description of the subselect and other syntax details of the create view statement, see the SQL Reference Guide.