Den 2014-02-28 00:58 skrev Dmitry Kuzmenko såhär: > > Friday, February 28, 2014, 3:29:34 AM, you wrote: > > KR> It seems I've been a bit sloppy when introducing new constraints in my > KR> database. At least I found one table with a record that has null in a > KR> column that I've altered to not null. > > KR> So, is there any nice convenient way to find all such records in all > KR> tables? > > Well, I have an idea that can make huge speedup of the "whole database > scanning > process" - you should check only those tables, > that have rdb$format > 1, because tables, that have rdb$format = 1 > was not altered since last restore or their first creation. >
Thanks Dmitry! I think I can figure it out either way (execute statement or C# app). I was trying to save some time ny not reinventing the wheel. :-) Regards, Kjell
