| Subject | Re: [firebird-support] How can I find a record in a table that has a null value where the field does not allow a null value? |
|---|---|
| Author | Doug Chamberlin |
| Post date | 2009-04-01T22:19:04Z |
SoftTech wrote:
2. Get rid of the nulls.
3. Change the field again to not allow nulls.
> I was just wondering if anyone else has found a way to find any record in1. Change the field back to allow nulls.
> any and all tables in a Firebird database that should not be null, but is.
>
> We all know how we get here. A field is added that allows nulls when first
> created and then it is later changed to not allow nulls.
>
> Any ideas on how this could be done or if there is already any tools out
> there that will do this?
2. Get rid of the nulls.
3. Change the field again to not allow nulls.