Subject Re: [firebird-support] Find all records on all tables that violate constraints?
Author Dmitry Kuzmenko
Hello, Kjell!

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.

Dmitry Kuzmenko,