3. Statements : OpenROAD SQL Statements : Create Table Statement
 
Share this page                  
Create Table Statement
The create table statement creates a base table.
Note:  This statement has additional considerations when used in a distributed environment. For more information, see the Ingres Star User Guide.
This statement has the following syntax:
create table [schema.] table_name
              (column_specification {, column_specification})
              [with with_clause];
The create table...as select statement (which creates a table and load rows from another table) has the following syntax:
create table table_name
              (column_name {, column_name}) as
                            subselect
                            {union [all]
                            subselect}
              [with with_clause];