Subject Re: [firebird-support] Find all records on all tables that violate constraints?
Author Kjell Rilbe
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