ckcat
asked on
Table dependency report.
Hi, Experts:
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?
Example:
tbl_Cars_Info
CarsTypeID (FK), tbl_Lookup_CarsType (PK Table), CarsTypeID (PK)
CarsMakeID (FK), tbl_Lookup_CarsMake (PK Table), CarsMakeID (PK)
tbl_Sales_Info
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
CKCAT
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?
Example:
tbl_Cars_Info
CarsTypeID (FK), tbl_Lookup_CarsType (PK Table), CarsTypeID (PK)
CarsMakeID (FK), tbl_Lookup_CarsMake (PK Table), CarsMakeID (PK)
tbl_Sales_Info
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
CKCAT
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
CKCAT ^_^