Hi all,
I have a table that has an Identity Field as the primary key. Originally, it was created with the original seed value = 1 and increment = 1. After I delete all the records in the table, how do I reset it so that the next record inserted starts back at 1 instead of where it last left off ??
JH.
I have a table that has an Identity Field as the primary key. Originally, it was created with the original seed value = 1 and increment = 1. After I delete all the records in the table, how do I reset it so that the next record inserted starts back at 1 instead of where it last left off ??
JH.