Re: Idendity column on MS SQL

Eugene V. Goldberg wrote:

Is there a way to set Idendity column seed back to 1 on existing
table after all the rows are deleted?

Use the DBCC CHECKIDENT statement:
http://msdn.microsoft.com/en-us/library/ms176057.aspx

You can also use TRUNCATE TABLE to delete all rows and reset the
identity counter.

--
Yorai Aminov (TeamB)
(TeamB cannot answer questions received via email.)
Shorter Path - http://www.shorterpath.com
Yorai's Page - http://www.yoraispage.com
.