Hi

Get IBExpert Personal Edition for free.
Start SQL Logging.
Remove "Not Null".
See log.

Regards,
Steffen


-----Original Message-----
From: Daniel Albuschat [mailto:daniel@...]
Sent: Monday, June 21, 2004 12:28 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Removing 'not null' constraint

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


------------------------ Yahoo! Groups Sponsor --------------------~--> Make
a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
Now with Pop-Up Blocker. Get it for free!
http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/67folB/TM
--------------------------------------------------------------------~->


Yahoo! Groups Links