>> I was just wondering if anyone else has found a way to find any record in
>> 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?

Database Workbench will issue a warning if you try to "not null" a nullable
existing field. It allows you to enter a value that will be applied before
applying
the not null constraint.

Take a look at www.upscene.com and download yourself the trial version
or the free lite edition.

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum:
http://www.databasedevelopmentforum.com