>It really shouldn't matter as the PK is used for internal use..referential integrity, etc.

A good point - plus if it's being used as a FK in another table it's going to be a problem resetting them - but I got the impression the data he had was just test data and was going to start with empty tables.
I have worked for someone before who "kind of" understood things and would ask me to do stuff like this just because it "looked better"...

>>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 .