|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
stupid coworker designed database with no identity keys.. :-(Discuss amoung yourselves; meanwhile I'm heading for the beach! Have a nice
weekend folks! 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! > > 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. -- Show quote---------------------------------------------------------------------------- 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) "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! > > |
|||||||||||||||||||||||