4. Maintaining a Distributed Database : Create Statement : Create Table Statement
 
Share this page                  
Create Table Statement
Use the create table statement to create new tables:
create table with with_clause
create table as subselect with with_clause
The create table statement creates an object of type table. The table is stored in a local database or the coordinator database, depending on the node_name specified in the with clause. By default, the table is stored in the coordinator database. The table is automatically registered in the Ingres Star catalogs as a native object. Tables registered as native are distinguished from tables registered as links by the value in the table_subtype column in the iitables catalog.