| Subject | Re: [firebird-support] Find all records on all tables that violate constraints? |
|---|---|
| Author | Dmitry Kuzmenko |
| Post date | 2014-02-27T23:58:02Z |
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, www.ib-aid.com
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, www.ib-aid.com