>>>>Is there a GUI tool for creating referential integrity between tables in SQL 2005? Or do need to do this via the ALTER TABLE command?
>>>Do you have SQL Server Management Studio? (it can be downloaded for free)
>>>I am pretty sure you can set up referential integrity between tables with that.
>>>If you have VS2005 pro you can also set up referential integrity in the server explorer.
>>
>>I must be blind, which particular part of those tools are you referring to?
>
>In the server explorer you can use the database diagrams section. Add the tables to the diagram and then drage constraints between PK and FK. I don't have the management studio installed on this machine yet, but I am sure it is similar.
>
>Einar

Thanks Einar, I thought that was just creating a diagram, I didn't know it was actually writing changes back to the database.

I must being doing something wrong here, are the relationship lines supposed to point directly to each of the fields in the tables, or do they just show the tables linked?