Home » Open Source » Programming Interfaces » Build DB structure based on SQL Statements
Build DB structure based on SQL Statements [message #574342] Wed, 09 January 2013 04:02
Messages: 16
Registered: November 2012
Junior Member

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
Previous Topic: .net connection to oracle
Next Topic: DOS script for adding an ODBC data source
Goto Forum:

Current Time: Tue Mar 05 02:14:44 CST 2024