View Single Post
TheMentat TheMentat is offline
Registered
 
TheMentat's Avatar
 
Join Date: Dec 2004
Location: Ocean Park, BC
Posts: 2,451
Garage
Quote:
Originally Posted by Scott at Pelican Parts View Post
I should emphasize that these tables were imported into SQL Server from a text file or something, so there are no existing relationships that I'm aware of -- these are just raw tables. What I'm trying to do is determine the relationships, not just display them.

Thanks again.
yikes...

I can't think of anything off the shelf. But if I were to do it manually, I'd do it by running queries on the system tables for the DB. Find out which fieldnames occur more than once in the DB, and then find out which tables they occur in.
__________________
Silver '88 RoW Carrera
Grey '06 A4 Avant
Old 03-28-2008, 11:06 AM
  Pelican Parts Catalog | Tech Articles | Promos & Specials    Reply With Quote #8 (permalink)