skip to main content
Reference : Supported SQL Statements and Extensions : Create Table
  

Try DataDirect Drivers Now

Create Table

Purpose

Creates a new local table in the machine on which the driver is running. A local table is exposed in the PUBLIC schema.

Syntax

CREATE [{MEMORY | DISK | [GLOBAL] {TEMPORARY | TEMP}]
TABLE table_name (column_definition [, ...]
[, constraint_definition...]) [ON COMMIT {DELETE | PRESERVE} ROWS
where:
MEMORY
creates the new table in memory. The data for a memory table is held entirely in memory for the duration of the database session. When the database is closed, the data for the memory table is persisted to disk.
DISK
creates the new table on disk. A disk table caches a portion of its data in memory and the remaining data on disk.
TEMPORARY and TEMP
are equivalent and create the new table as a global temporary table. The GLOBAL qualifier is optional. The definition of a global temporary table is visible to all connections. The data written to a global temporary table is visible only to the connection used to write the data.
Note: If MEMORY, DISK, or TEMPORARY/TEMP is not specified, the new table is created in memory.
table_name
specifies the name of the new table.
column_definition
specifies the definition of a column in the new table. See "Column Definition for Local Tables" for a complete explanation.
constraint_definition
specifies constraints on the columns of the new table. See "Constraint Definition for Local Tables" for a complete explanation.
ON COMMIT PRESERVE ROWS
preserves row values in a temporary table while the connection is open; this is the default action.
ON COMMIT DELETE ROWS
empties row values on each commit or rollback.
* Column Definition for Local Tables
* Constraint Definition for Local Tables