Hi,

>>> > Now I'm really puzzled!
>>> Why? A primary key requires non-null columns.
> I know that! ;-)
>
> My puzzlement is because Mike supplied a script that doesn't set the ID
> column to NOT NULL and which, when he runs it, executes with no errors
> when adding (with ALTER TABLE ADD CONSTRAINT) a primary key on the ID
> column. I'm actually running the identical version of Firebird as Mike
> is, and it fails when I try to run his (working) script.
>
> I don't (yet) know if Mike is getting his ID column redefined silently
> to be NOT NULL, I suspect so.

If you create the PK as part of the CREATE TABLE statement, then yes,
it will be set to "not null" automagically.

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum:
http://www.databasedevelopmentforum.com