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];