Yes it applies to all versions of SQL Server. You can only create a foreign key against and ENTIRE primary key OR ENTIRE unique index.
You may be able to do it in Oracle, but there has to be some guarantee of uniqueness otherwise how do you know which parent row the child row(s) relate to?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question