Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Auto-incrementing primary key?
On Tue, 20 Jan 1998 18:23:10 -0500, jeb <jeb_at_fayettevillenc.com> wrote:
>Reconsider the database design. Usually this type key is only used in
>improperly designed table structures...
>
Really? ;)
What about:
UIDs that may be updateable?
UIDs that propagate through several levels of relations resulting in unwieldy PK's and FK's?
Data redundancy introduced by intelligent keys?
Proper relational design also requires that the PK has no meaning. ( At least according to CJ Date ) Received on Fri Jan 23 1998 - 00:00:00 CST
![]() |
![]() |