Subject | Re: [firebird-support] Removing 'not null' constraint |
---|---|
Author | Daniel Albuschat |
Post date | 2004-06-21T11:46:53Z |
On Monday 21 June 2004 13:11, Steffen Heil wrote:
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
> Get IBExpert Personal Edition for free.Thanks for this great tip!
> Start SQL Logging.
> Remove "Not Null".
> See log.
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