OR 11.2 | Create Table Statement

System Reference Summary > System Reference Summary > Statements > OpenROAD SQL Statements > Create Table Statement

Was this helpful?

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.

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

Last modified date: 12/20/2023