CREATE TABLE

 

Function

CREATE TABLE command will create 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_table.bmp

 

COLUMN Clause:

column_clause.bmp

 

Table Specification:

See Table Specification.

 

SQL Data Type:

See SQL Data Types under SQL Language Elements.

 

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.

 

Example:

CREATE table test (companyname char(20), companyid integer, companybudget double)