As pointed out by
NotPolitcallyCorrect[
^] you probably use an automatically incrementing identity.
First of all since this kind of key definition serves only as a unique identifier for a single row, it should not matter what the value is. 1000 is just as fine as 1, since it just identifies a row.
You will probably always have gaps in the numbering. For example if
- you add three rows in the table: 1, 2, and 3
- you delete row 2
- you now have rows 1 and 3
If you still want to reset the identity, have a look at reseeding the value with
DBCC CHECKIDENT (Transact-SQL)[
^]