Subject Re: [firebird-support] Removing 'not null' constraint
Author Daniel Albuschat
On Monday 21 June 2004 13:11, Steffen Heil wrote:
> Get IBExpert Personal Edition for free.
> Start SQL Logging.
> Remove "Not Null".
> See log.

Thanks for this great tip!

The way to do it is:

update RDB$RELATION_FIELDS set $RDB$NULL_FLAG = null
where RDB$FIELD_NAME = 'My_FieldName' and
RDB$RELATION_NAME = 'My_TableName'

cu,
Daniel Albuschat

--
eat(this); // delicious suicide