Re: SQL Parser failing on NULL column contraint

[Duncan Groenewald]

Can someone confirm that the following statement will fail because Derby 
can't handle a NULL constraint

create table SampleTable(
   code int   NOT NULL,
   description varchar(32) NOT NULL,
   address varchar(256)  NULL,
   phone varchar(32) NULL
   )
whereas this will work fine

create table SampleTable(
   code int   NOT NULL,
   description varchar(32) NOT NULL,
   address varchar(256),
   phone varchar(32)
   )

Any chance someone can explain how I could modify the parser (or 
whatever) to be able to handle the NULL constraint ?

Thanks
Duncan