|
Posted by Tom on 10/11/05 23:44
Thanks for the actual terms for these key thingies.
I've searched google but found a lot of different opinions.
Some like autonumber but some like... huh... natural key.
To sum it up from all the posts I've read:
1)
The people who use autonumber said that it performed better and easier to
update the record without affecting the database integrity. (imagine
someone needs to change his or her social security number!!!! all hell broke
lose!!!)
2)
The people who use natural key said that people who use surrogate were just
lazy and not experience with database design. And using natural key could
better model database to the business model.
So... I don't know... that's why I am so confused.
One has physical advantage. The other has logical advantage.
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@acm.org> wrote in message
news:1129060967.267313.134080@z14g2000cwz.googlegroups.com...
> "For everything" is a pretty obscure answer. Other keys are important
> too. In a joining table containing only two foreign keys for example
> what purpose would IDENTITY serve?
>
> Tom, for the debate you can Google for "Natural Key" and "Surrogate
> Key" in this group and in microsoft.public.sqlserver.programming.
>
> --
> David Portas
> SQL Server MVP
> --
>
Navigation:
[Reply to this message]
|