NexusDB

NexusDB supports SQL DDL, which means that you may Create Tables and Indices through SQL. Here are SQL DDL statements to create the Products Table:

CREATE TABLE PRODUCTS

(

       PRODUCTID AUTOINC NOT NULL PRIMARY KEY,

       NAME VARCHAR(64) NOT NULL,

       RETAILPRICE MONEY NOT NULL,

       WHOLESALEPRICE MONEY NOT NULL,

       MANUFACTURERID INTEGER NOT NULL,

       PRODUCTNUMBER VARCHAR(64) NULL,

       DESCRIPTION TEXT,

       THUMBNAIL IMAGE,

       PRODUCTIMAGE IMAGE,

       CREATED DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL,

       MODIFIED DATETIME NOT NULL

);

CREATE INDEX I_NAME ON PRODUCTS (NAME IGNORE CASE);

CREATE INDEX I_MANUFACTURERID ON PRODUCTS (MANUFACTURERID);

CREATE INDEX I_PRODUCTNUMBER ON PRODUCTS (PRODUCTNUMBER);

By using standard SQL data types, the Products table that is created from the SQL DDL, is not exactly the same as the one created by the Data Dictionary code. There are four differences:

The full SQL DDL is covered in detail in the SQL reference chapter. Using SQL DDL is the most database neutral Table creation method.