I have to say that the client should never get a say in things like the primary key since he should never see a table's primary key. Perhaps he really just wants an incrementing candidate key to look at?

Gary


>Hi All,
> I have a primary key in one of my table. When the record is added the primary key is increased to next number. I have been testing and the primary key is 100, however my client want the primary to start to one. Thus, is there a way that would allow me to reset the primary key back to 1.
>
>Thanks, this will save me .