Is there a way to find what tables are needed to form a relationship between two tables?
For example, I have an tblssue, tblElementType, and 22 other tables. There isn't a direct relationship between tbIssue and tblElementType but through tblIssue -> tblA -> tbl... -> tblZ -> tblElementType there could be a relation. Is there a way to found out what tblA -> tbl... -> tblZ are?
Create a database diagram in Visio. It'll show the FK relationships.
Adamus
No comments:
Post a Comment