MS SQL 2000 Phantom Relationship [Resolved]
This is just a general query, i've got 2 tables in a database that have no relationship to each other
Project
Project_UDF
They both have a field called Project_ID and these 2 fields are the Primary Key of their respective tables.
When i import them into the query designer or the diagram tool it automatically assumes a link on Project.Project_ID = Project_UDF.Project_ID which is correct but how did it know this?
Thanking you all in advanced
Sam
Re: MS SQL 2000 Phantom Relationship
Quote:
Originally Posted by señorbadger
This is just a general query, i've got 2 tables in a database that have no relationship to each other
Project
Project_UDF
They both have a field called Project_ID and these 2 fields are the Primary Key of their respective tables.
When i import them into the query designer or the diagram tool it automatically assumes a link on Project.Project_ID = Project_UDF.Project_ID which is correct but how did it know this?
Thanking you all in advanced
Sam
it assumes. Since each table has the same name and both of them are the primary key it assumed that they are related.
Re: MS SQL 2000 Phantom Relationship
Thanks for that, i had a feeling it was but wanted someone to confirm it
