Hi Robert,

> How do I use alter table to make a column allow nulls that didn't
> allow them before? The documentation for the "alter table" was
> unclear on this point.

It involves a system table update. Download yourself a trial copy
of Database Workbench - www.upscene.com - start the Table
Editor and change the "Not NULL" flag. Use the DDL tab to
view the statement or simply press the "Save" button :)


With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."