CREATE TABLE
Function
The CREATE TABLE command creates the specified table on the specified target database. For non-relational databases, CONNX creates a data structure on the target system that closely approximates the requested relational table.
Syntax
CREATE [TEMP] TABLE table_specification (COLUMN clause[,])
Syntax for the COLUMN clause:
column_name SQL Data Type [[NOT] NULL]
where
table_specification | |
SQL Data Type | |
Note:
CREATE TABLE is currently not supported by CONNX for VSAM or Codasyl DBMS.
Using the TEMP keyword, CREATE TABLE can create temporary tables. Temporary tables can contain indexes; they support all the standard SQL data types, including CLOBs BLOBs, and unicode data. Temporary tables are private to the connection on which they were created and will be deleted when the connection is closed.
Examples
CREATE table test (companyname char(20), companyid integer, companybudget double)