How to reset the seed of identity column?

[soyo20]

I create a table in my DB which has a identity column.
I insert many row and the value of identity increase correctly. Now I want to delete all the rows and reset the identity value to its seed to restart. I failed. Can you instruct me HOW TO RESET THE SEED OF THE IDENTITY COLUMN?

Thank you very much

 

[SonOfEmidec1100]

Use TRUNCATE TABLE tablename to delete all the rows - this will reset the identity seq number as well.

 

[phinoppix]

see thread222-595019

 

[TDK2001]

You could use DBCC CHECKIDENT('tablename', RESEED, 0)

Tim

 

[soyo20]

Thanks everybody a lot