Creating Tables

Create the tables using the CREATE TABLE command. The example databases described in the Quick Start include sample SQL scripts that demonstrate this procedure. For example:

CREATE TABLE Product_Dimension (

Product_Key INTEGER NOT NULL,

Product_Description VARCHAR(128),

SKU_Number CHAR(32),

Category_Description CHAR(32),

Department_Description CHAR(32),

Package_Type_Description CHAR(32),

Package_Size CHAR(32),

Fat_Content INTEGER,

Diet_Type CHAR(32),

Weight INTEGER,

Weight_Units_Of_Measure CHAR(32),

Shelf_Width INTEGER,

Shelf_Height INTEGER,

Shelf_Depth INTEGER);