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