How to reset Identity column

[rsrinivasan]

Hi all,

I have a table with one identity column. I want to reset that column from 0(zero).
How can i achive it.

Thanks,

[Delerna]

Do you mean reset it TO zero ? Is the table empty of records?

Design the table
Turn identity off
close and save the table
design the table
turn identity back on
close and save the table

the identity count is now reset

I hope you don't have other tables with data that is referencing this table you are resetting