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
Refers to the object identifier. This must be specified.
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.