By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,364 Members | 1,268 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,364 IT Pros & Developers. It's quick & easy.

How to reset Identity column

rsrinivasan
100+
P: 221
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,
Jun 16 '08 #1
Share this Question
Share on Google+
1 Reply


Delerna
Expert 100+
P: 1,134
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
Jun 16 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.