Identity Question

[bongmarley]

I was wondering if there is a way to set the field I am using as my primary key with the identity seed back to 1. I put in 10 records as a test and then deleted them. Now when I put in a new record it starts at 11. is there any way to reset this back to 1.

 

[sunila7]

Hi,

have a look at DBCC CHECKIDENT in SQL BOL. here is the link

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_dbcc_5lv8.asp

or instead of deleting if u truncate the table then also Identity fld will be reseeded.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ta-tz_2hk5.asp

Sunil