SQL Server Management Studio – adding foreign key confusing?
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 … Read more