SQL Server Management Studio - adding foreign key confusing?

Question

I always find it confusing to add foreign keys to primary table in Management Studio.

Lets say I have a

Table1  {     ID int, -- Primary Key     Table2ID int, -- Refers to Table2's ID  }  Table2  {     ID int, -- Primary Key     SomeData nvarchar(50) } 

I am adding a foreign key to Table1 by Right Click -> Relationships -> Table and column specification. I am setting "Primary" popups to Table2, ID and "Foreign Key Table" to Table1, Table2ID.

My questions:

1. Shouldn't Table2 be listed for "Foreign Key Table" and Table1 for Primary Key? Is my understanding wrong?

2. When I save I get an alert "The following tables will be saved to your database." and it shows both tables. I really don't get this. I only changed Table1. Why is the second table shown?

Answer 1

• Click the expand symbol next to the table.
• Right click on the "Keys" folder and select "New Foreign Key."
• (Alternatively, you can click the Relationships button on the toolstrip when you have the table open)
• Click the "..." button on the "Tables and Columns Specifications" row to open the editor.
• The drop down on the left will be the table you're adding from, and the static text field will list the table you're adding to.
• Use the dropdowns to specify your constraints, and be sure both sides have the same number of columns.