All geek questions in one place

Finding relationships on many tables

I inherited development with nearly 800 tables. I need to create reports covering several tables. I use SQL Dependency Tracker to help me find the tables I need, but even that hurts.

Do you know about an application that I can say [start table] [end table], now find all the tables between them?

Any ideas? Thanks

+4
source share
1 answer

I understand that you are looking for a ready-made application to do this work, but if you do not find it better than SQL Dependency Tracker, here is a tip so you can start writing your own:

For SQL Server The SQL Server Object Dependency List describes 4 different ways to programmatically determine immediate neighbors. The SQL script for displaying table dependencies provides a complete script for this in Oracle (although, unfortunately, this Oracle solution requires membership in Expert Exchange to see the answer.)

This allows you to get immediate neighbors, so you will need additional coding to repeat and search until you reach the final goal that you want to connect.

+2
source

Source: https://habr.com/ru/post/1306496/

More articles:


All Articles