I am using SQL Manager Lite to try to run a DDL Create Table script. I am new to Firebird and I don't know why it isn't working. The following script...
create table Contacts (
ID integer not null,
FirstName varchar(64) not null,
LastName varchar(64) not null,
MiddleInitial varchar(1) null
);
Is causing a parsing error (UNIDENTIFIED TOKEN) on the null constraint for the MiddleInitial column.
Here is the exact error returned by Sql Lite...
Invalid token.
Dynamic SQL Error.
SQL error code = -104.
Token unknown - line 5, column 52.
Null.
Is the NULL constraint not allowed in Create Table DDL for firebird?