Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread Keep Integer for Primary Key?
Tue, May 6 2008 12:57 PMPermanent Link

"keith crusius"
Since I have decided to use guids for all my record identifiers, is there
any reason to keep a generated (autoinc) integer field as the primary key on
a table?  Or is it just wasting space?
Tue, May 6 2008 10:12 PMPermanent Link

Lance Rasmussen

Jazzie Software

Avatar

Team Elevate Team Elevate

In general, there isn't.  I've moved to GUID's as well.  I do, however, keep
an autoinc for display purposes and for 3rd parties, but don't use it
myself.

Lance

"keith crusius" <keithcrusius@hotmail.com> wrote in message
news:4C645C2D-E0EA-448F-8BFD-6A91BB6834C4@news.elevatesoft.com...
> Since I have decided to use guids for all my record identifiers, is there
> any reason to keep a generated (autoinc) integer field as the primary key
> on a table?  Or is it just wasting space?
Image