Marshall Spight (mspight_at_dnai.com) writes:
> "Christian Antognini" <christian.antognini_at_trivadis.com> wrote in message
news:410affcf$1_at_post.usenet.com...
>>
>> A PK should have no business meaning.
>
> Says who? Can you justify this statement?
Because most real-world look-like keys do not live up to the strict
requirements of the primary keys in a database. They are too often
nullable or non-unique. Person identification numbers such as SSN
are a good example of both.
--
Erland Sommarskog, SQL Server MVP, esquel_at_sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
Received on Sat Jul 31 2004 - 17:11:00 CDT
