Re: What is a Artificial Key??

Example:
If I would have to create a dutch address table, I could make a primary key consisting of the postal code and the number, as these are supposed to be unique. However, when I have multiple individuals on one address that might not be a good idea.
That's the reason to add an auto-generated number to that table and make that column the artificial key.

Hth,

Sybrand Bakker, Oracle DBA

<liam_2e_at_my-deja.com> wrote in message news:88uckm$46u$1_at_nnrp1.deja.com...
> I have been trying to find this out, but I cannot find out what a
> artificial or generalized key is??Thanks for the help..Liam
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Feb 22 2000 - 11:07:04 CST