I had found it efficient to create a cross-reference spreadsheet for tables vs. columns as well as one for columns vs. tables in a relational database during the course of executing my software development work. It enabled me to quickly look up tables and columns without having to connect to my database and search for the occurrences of a column (sometimes in multiple tables) and other, similar searches.
The basic idea was to use a SQL query to get records of tables and columns (with their properties) of a relational schema and to then use the MS Excel Pivot tables to create two tabs based on that those records; one for Tables vs. Columns and one for Columns vs. Tables.
I have posted a sample here:
Tools/Tables and Columns Cross-Reference.xlsx at main · Crimson-Reason/Tools
No comments:
Post a Comment