||SQL Server Tips by Gama and Naughter
A foreign key enforces referential integrity by requiring that the
values from a column either exist in a referenced table or are NULL.
Relationships between tables are established by defining primary
keys or unique keys and referencing them with foreign keys.
Example: To create a one to many relationship between Table1 and
Table2. Table1_ID is the name of the column that is the primary key
from Table1; Table2_f is the foreign key from Table2 that will
relate both tables.
ALTER TABLE dbo.Table2 ADD
FK_Table2_Table1 FOREIGN KEY
) REFERENCES dbo.Table1
For a one to one relationship, both related columns must be primary
keys. In this example, Table2_f should be a primary key or unique. A
column can be a primary key and a foreign key simultaneously.
The above book excerpt is from:
Turbocharge Database Performance with C++ External Procedures
Joseph Gama, P. J. Naughter