| Build DB structure based on SQL Statements [message #574342] |
Wed, 09 January 2013 04:02 |
 |
isri
Messages: 16
Registered: November 2012
|
Junior Member |
|
|
Hello,
I'm working with database that has few hundred tables, but only few tables has foreign keys constraints set. Everything is managed by closed source application that works on the DB.
There are many 'unofficial' foreign keys - I mean there are columns in many tables which are storing the values could be used to build foreign keys.
I have few thousand of SQL Select statements that represent those relations, but those are very complicated, containing multiple sub statements. Additionally some are written with JOINS (I mean Inner, Outer, Right, Left...) some with Oracle + notation.
I'm thinking about writing a script (maybe in Perl) that would be able to retrive those relations from those statements.
Do you know if there are any simmilar tools (or Perl modules) that already exists and could help me with that?
Many thanks
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
