create table with text not null

Erich Geiersberger erichg at mcmm.com
Fri Jun 13 05:16:23 CDT 2008


The following statement:

CREATE TABLE "TEST_T2" (
    "ID" SHORT  NOT NULL INDEXED,
    "Description" TEXT (512) NOT NULL,
    "Point" VARCHAR (12)  NOT NULL);

should create a table with field "description" being defined as not 
containing NULL values, right?.
Is there something wrong with that statement?

Dumping that table results in:

-- Dump for 'TEST_T2' table
----------------------------------------------------

CREATE TABLE "TEST_T2" (
    "ID" SHORT  NOT NULL INDEXED,
    "Description" TEXT (512) ,
    "Point" VARCHAR (12)  NOT NULL);

???

Erich Geiersberger
Media Connect
Augsburg, Germany


More information about the Valentina mailing list