|
Table Data Inspector is an utility intended for Progress
database tables relations integrity analysis. It is
able to identify the tables relations automatically
or pick the from a user-defined
joins list. It finds all Foreign Keys (FK) entries
for the selected child tables where no Primary Key entry
(PK) exists.
The utility also can help you with fixing the problem,
with more detailed problem analysis, and with export
of the analysis results to the different formats (to
HTML, comma separated list, MS EXCEL etc).
top
Table Data Inspector is available from PRO4m Dynamic
DB Browser's main screen as well as from its window
menu.
To start Table Data Inspector, open Dynamic DB Browser,
select a table (Customer
table - Sports database was used for the examples below)
and click “Inspect”
button (or choose Options
-> Table Data Inspector menu item).
** Click on image to preview in a
separate window
Select “Quick Check”
option (“Quick Check”
will show you only one, first found missing FK entry
per table), select tables from the list (switch between
Parent and Child tables lists if required) and START
the table data inspection:
** Click on image to preview in a separate
window
A Parent Tables list is showing all Parent tables relations
queries for the selected inspecting table (Customer
in our case), where Customer
table is a child table for them, and a Child Tables list
is showing all child tables relations queries, where Customer
table is a parent table for them.
A prompt window
will ask you to confirm the operation, when you have
the START
button clicked:
top
When inspection process is completed an inspection
results window will be opened automatically for the
results preview:
** Click on image to preview in a separate
window
top
How to understand Table Data Inspection results?
- It’s really simple. Have a look at the example
above. Table Data Inspection results are shown there
for the tables relationship “Customer
-> State”, where State is a Parent table
to Customer defined by “Customer.State
-> State.State” fields. So, Inspection
results browser shows a Customer record with not blank
Customer.State field where
no State.State record found
for the found Customer.State
value (“Bretagne”).
This may have happened when a State
table record has been deleted (or State.State
field updated) without the Customer
table data validation for the existence of proper Customer.State
values (so, Restrict Delete, or Cascade Delete, or Cascade
Update rule could apply to Customer
table to avoid such situation).
top
Just to remind you that what we were doing was a table
data inspection in a “Quick
Check” mode. It has shown us quick
relations analysis results. To show all the missing
FK entries you'll have to do the following:
Close Inspection results window, and click “Options”
menu, choose “Deselect
relations with no problem found”.
It will deselect all tables relations where no problems
found to not to spend time analyzing it again.
This time analysis may take longer time.
** Click on image to preview in a
separate window
top
To see how many Customer
table records qualify for the found missing Foreign
Key (FK) reference - select one or several browser's
lines and click “Count
Rec Total” button. Number of qualified
records will be shown in “Rec
Total” browser column for every
selected browser line.
top
To preview qualified query records in our DB Browser
– select a resulted query browser line (just one)
and click “Open
in Browser” button:
** Click on image to preview in a separate
window
A Dynamic DB Browser window will be opened for the
selected query:
** Click on image to preview in a
separate window
top
To export all or selected inspection results records,
use “Export Results”
button. See our Data Export
module description here.
top
|
You Are Here: PRO4m Documentation
> Table Data Inspector;)
;)
',0,0);)
',0,0);)
',0,0);)
;)