In SQL Server 2000, does a FK HAVE TO BE defined as relating back to a PK --- or can it relate back to any generic column of similar, non-primary key data type and length?
The foreign key has to refer to a column of same type and length enforced by a unique constraint (index)... it doesn't have to be a primary key nor the clustered index (however strongly suggested).
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply