Posted by Greg D. Moore \(Strider\) on 10/12/05 02:48

<dbahooker@hotmail.com> wrote in message
news:1129052916.884917.318460@o13g2000cwo.googlegroups.com...
> no greg im serious
>
> why is it bad advice?

Because it doesn't necessarily model reality.

>
> i just dont believe in tables that dont have a single numeric primary
> key.

So if you were designing a database of cars you'd create your own single
numeric primary key rather than VIN?

Or if you were designing a database for Books you'd eschew the ISBN and use
an Identity column?


>
> I'm just too friggin tired to use 'A345FD' as a primary key anymore..

Then I suggest you get some more sleep.

> use INTs or BIGINTs if you want. i would rather use a bigint than a
> varchar any day of the week
>
> but.. i mean.. no keys?

Who said anything about no keys. Certainly not I. It's not a table w/o
keys.

>
> are you drunk?

Not hardly.


>

• Next in forum: Re: AutoNumber vs. Key
• Prev in forum: Re: Changing the 6th character of a string?
• Thread view: Re: Index corruption on table without key: what could be the reasons ?

[Reply to this message]