Well, length of an integer field is always the same... but I understand what you want to mean, because I am on the same situation
I guess you are looking for an ID to identify records, but It's not convenient that the ID indicates the order of creation In my case, is the affiliate ID, and I've been asked generating an 3 or 4 digits number automatically, also I need multiple database syncronization, so I am thinking on creating an auxiliar table with indexes Anyone has a simpler solution? On Jun 30, 9:34 pm, Martin Weissenboeck <[email protected]> wrote: > Hi, > > is it possible to create a new table with an id-field not starting with 1. > I think it would be better to have numbers of equal length. > > And - if it's possible - does it reduce efficiency? > > Regards., Martin
