I've inherited an Oracle database with about 200 tables and no fixed referential structure. The naming convention specifies that each field contain a prefix identifying the table the field belongs to in, so the primary to foreign key structure is as follows:
select
a.a_pk, b.b_pk, c.c_pk
from
a, b, c
where
a.a_pk = b.b_a_pk
and
b.b_pk = c.c_b_pk
All automated schema documenters or reverse engineering applications that I've tried won't identify or vizualize the relationships because they expect the pk and fk names to be the same. Is there any tool out there where I can define the key structure?
Thanks
select
a.a_pk, b.b_pk, c.c_pk
from
a, b, c
where
a.a_pk = b.b_a_pk
and
b.b_pk = c.c_b_pk
All automated schema documenters or reverse engineering applications that I've tried won't identify or vizualize the relationships because they expect the pk and fk names to be the same. Is there any tool out there where I can define the key structure?
Thanks