Table dependency report.
Posted on 2003-10-23
I am trying to try the query to go through each table in my database and list its dependencies. (Foregn Keys). Any idea how to do that?
CarsTypeID (FK), tbl_Lookup_CarsType (PK Table), CarsTypeID (PK)
CarsMakeID (FK), tbl_Lookup_CarsMake (PK Table), CarsMakeID (PK)
SalesTypeID (FK), tbl_Lookup_SalesTypes (PK Table), SalesTypeID (PK)
Group by table names
List the foreign key of the table, list the table it is depending on, list the primary key of the lookup.
Thanks a lot