Home All Groups Group Topic Archive Search About

stupid coworker designed database with no identity keys.. :-(

Author
2 Sep 2005 12:50 PM
Tony
Discuss amoung yourselves; meanwhile I'm heading for the beach! Have a nice
weekend folks!

Author
3 Sep 2005 8:12 AM
Mike John
Not necessarily depending on whether you meant:

No columns defined as identity columns
or
No columns defined as keys

If the first then I would say that Identity is a *possible* way of
generating internal artificial identifiers that can sometimes be useful. But
nothing suggests that should *always* be used.

If the second then yes it needs looking at to define the right keys.

Mike John




Show quote
"Tony" <some***@microsoft.com> wrote in message
news:uAymK17rFHA.2072@TK2MSFTNGP14.phx.gbl...
> Discuss amoung yourselves; meanwhile I'm heading for the beach! Have a
> nice weekend folks!
>
>
Author
3 Sep 2005 1:16 PM
--CELKO--
Did you get a real key instead?  Or just no key at all?
Author
4 Sep 2005 4:22 AM
Louis Davidson
Um, okay.  There is not requirement to use identity keys, none whatsoever.
Do you have primary keys (and some reasonable method for creating unique
values for them?)  That is required.  By no means does not using identities
make you stupid.  Now, using an identity key and no other unique key, that
my friend, is another question all together.

Hopefully later you will give more information.

--
----------------------------------------------------------------------------
Louis Davidson - http://spaces.msn.com/members/drsql/
SQL Server MVP
"Arguments are to be avoided: they are always vulgar and often convincing."
(Oscar Wilde)

Show quote
"Tony" <some***@microsoft.com> wrote in message
news:uAymK17rFHA.2072@TK2MSFTNGP14.phx.gbl...
> Discuss amoung yourselves; meanwhile I'm heading for the beach! Have a
> nice weekend folks!
>
>

AddThis Social Bookmark Button