FireDAC – database structure
Has any of you written code that analyses foreign keys to find structural dependencies between tables? Are there components out there which can do the job for me?
FireDAC – database structure
Published
I rant, therefore I am.
Which database? TMS Data Modeler has a feature to reverse engineer its supported database, and it`s a lot less expensive than ER Studio or ER/Win.
http://www.tmssoftware.com/site/tmsdm.asp
Bruce McGee – SQL Server, but I want to do it in Delphi (a diagnostic data drilling tool). Select a row, click on foreign key column, and drill to the linked row in the linked table.
IN SQL Server all these dependencies are retrievable via system tables and views. So you have “just” to get the knowledge where to find it …
Klaus Edelmann – True, but I was hoping to leech off the previous work of someone else 🙂
The structures are available in “standardized” form through FireDAC as well. http://docwiki.embarcadero.com/RADStudio/XE7/en/Metadata_Structure_(FireDAC)
http://docwiki.embarcadero.com/RADStudio/XE7/en/Working_with_Metadata_(FireDAC)
🙂
Devart TmsMetadata from SDAC does the Job.
http://www.devart.com/sdac/