Hi Ed,

> How do I drop a 'not null' on a FK on an existing db table field?

There's no DDL statement to do this. The "official way" is to drop and
recreate the FK field (and save the data in a temp column for the time
being). By the way, this goes for all not null constraints, not only
on FK columns.

But if you know what you are doing you can also drop it via the system
tables, or use a tool that does it for you (Database Workbench can do
it for instance).


Greetings,
Paul Vinkenoog