> > Is there a way to add a NOT NULL constraint to a column, with ALTER TABLE ? (Interbase 6).
>
> ALTER TABLE ADD CONSTRAINT MyColNotNull
> CHECK (MyCol is not null);

But unlike "true" not null constraint, you can't create pk/unique constraint
on such column.

Ivan
http://www.volny.cz/iprenosil/interbase