Reset Identity value

[omarmtz]

I have the following:

create table a (
col1 int identity,
col2 varchar)

insert into a values ("test1&quot --> col1 = 1
insert into a values ("test2&quot --> col1 = 2
insert into a values ("test3&quot --> col1 = 3

but when i do a delete from a, and insert a new value, the identity value continues (col1 = 4)... i want to reset the value, but not using DROP!
Is there a function or method to reset the identity value??

 

[dky1e]

If you do: 'truncate [tablename]' then the identity column will be reset.

 

[dky1e]

also, you can take a cool at:
DBCC CHECKIDENT