IDENTITY COLUMN - TechRepublic
General discussion
June 21, 2001 at 10:00 PM
ssingh

IDENTITY COLUMN

by ssingh . Updated 25 years ago

I have an identity column in my table and after deleting all the rows of a table (say 10 rows, where last identity value is 10. ) if I start inserting rows the identity value is coming 11, which is not required.
I want to restart my Identity columnvalues from 1…..I tried from Enterprise Manager by deleting Identity column and again creating it, but it didn’t work.

Please give me the solution.

This discussion is locked

All Comments