Add a unique constraint of a sql table as foreign key reference to an another sql table

Question

how to add a unique constraint of a sql table as foreign key reference to an another sql table in sql server 2005

Answer 1

You need to keep in mind that adding a FK on a column does not automatically put an index on that column. You'll need to do this in two steps.

1) Make a column in your table a FK to a parent table.
2) Add a unique constraint on that same column