Reseeding the identity
I have a table in a development db that has had data added to it and cleared from it several times. As a result, my primary key value is getting very large. Is there any way to reset the PK value back to the increment seed value without dropping the table and recreating it?
Thanks in advance for your comments.
- - - - - - - - - - - - - - - - - - - - - - -
In God we trust, everything else we test.
|
