View the table relationships in a database
I am using Excel and would like to use ADO to go into a database located on a
SQL server and view the relationships between the tables. Basically, if the
table STORES has a primary key field STOREID I would like to see the foreign
keys that are associated with it. Is this possible? If so, can I get the
"result" exported to a text file so I can view each relationship?
Thanks!!!!
|