Subject Re: [firebird-support] Removing NOT NULL from a domain
Author Helen Borrie
At 10:10 PM 29/08/2007, you wrote:
>I have created a not null domain. I would now like to alter this
>domain and remove the not null constraint. This is not supported by
>alter in firebird and I haven't been able to find a solution even
>through extensive googling. Is there any sort of workaround for this?
>Any suggestions how to remove the constraint without much hassle?

Create a new domain that is fully compatible with the existing one
but make it nullable. Then try to alter table...alter column blah
type newdomain for each column you want to make nullable. However,
you won't be able to do this change to any column that is a primary
key element or is subject to a CHECK (value is not null) constraint.