Hi Adam,

> G> I would like to have the ability to set or remove the "NOT NULL"
> G> requirement on a field using the alter table statement.
>
> I think it's already recorded as a feature request.

That being said, it CAN be done via a couple of system table
updates.

There are GUI tools available that wrap this up quite nicely
for you :-)

Geez, do I happen to know one.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com