On Monday 21 June 2004 11:36, Martijn Tonies wrote:

> Hi,
>
> > I've done some research already, but there seem to be
> > no way to remove the `not null' constraint from a column, is there?
>
> Not via standard DDL, no.
>
> You can do this via some system table updates and a
> DROP CONSTRAINT <system defined constraint name>

How do I get the constraint name?
I already had a look at RDB$CHECK_CONSTRAINST
but couldn't find out how to do it...

> Alternatively, download yourself a trial version of
> Database Workbench ( www.upscene.com ),
> fire up the Table Editor and simply uncheck the
> "Not Null" checkbox.

Well, I already have a program that can do this. But I don't
think my customers want to log into the database and drop
this constraint on the next application update. :)

Thanks for your help,
Daniel Albuschat