DelphiFAQ Home Search:

How to reset or reseed the IDENTITY column


comments7 comments. Current rating: 5 stars (1 votes). Leave comments and/ or rate it.

How can I reset or reseed the IDENTITY column?

See DBCC CHECKIDENT in SQL Server Books Online.

A quick and dirty way to reset the IDENTITY column would be to run TRUNCATE TABLE command on that table. TRUNCATE TABLE will delete all the rows from the table and reset the IDENTITY column. However, you will not be able to run TRUNCATE TABLE on a table referenced by foreign keys.

Content-type: text/html


2009-01-19, 22:55:19
anonymous from India  
dbcc checkident('Table_name',RESEED,0)
here 0 means where u want generate id. if u put 0 means id will generate from 1
2014-03-18, 13:31:15
How can any review of the purchasing managers' data using the instruction select add a field showing the first record numbers 1,2,3 ... always tidy
Thank you
2015-02-01, 04:14:58
anonymous from United States  
Thta's the best answer of all time! JMHO
2017-02-23, 05:42:47
Bridget from Buffalo, United States  
The day of his death, March 17, became the day to celebrate the Saint in Ireland and across the globe.
2017-02-24, 06:52:37
jimmy loof  
My life was falling apart, I was being cheated and abused, I had to know the truth and needed proof. I contacted a private investigator that linked me with who took care of the hack job. He hacked her iphone,facebook,instagram, Whatsapp,and email account. I got all I wanted as proof . I'm glad i had a proven truth she was cheating . Contact him for any hack job. Tell him i referred you to him, he will surely meet your hack need. Contact: he will be glad to help you.
2018-03-20, 08:49:26
anonymous from United States  
2019-08-13, 19:34:21
investing in oil and gas has and is still making a lot of people ' very RICH'. Investors in oil and gas are getting rich daily. All you need is a secured and certified strategy that will keep your invested capital safe by opting out with no withdrawer crunch. A considerable number of investors worldwide have seen gains of 75,063%, personally I have made over 600%. For example I started investing with $1,000 and I made $3,000, $3,500- $5,000 weekly. Last year at the start of the year, I increased my invested capital to $10,000 and I made approximately $105,000 before the end of year. I've never seen profit opportunities like this before in any market even when other traders complain of losses. Now for the doubters, not only is it possible, it's actually happening right now. All you need is a good and secured strategy, a good investment platform, Appetite and market conditions. Incase you are interested in venturing into investing or perhaps you are trading and has been losing, feel free to contact total companyat E-mail: I will
be sure to guide and assist you.



NEW: Optional: Register   Login
Email address (not necessary):

Rate as
Hide my email when showing my comment.
Please notify me once a day about new comments on this topic.
Please provide a valid email address if you select this option, or post under a registered account.

Show city and country
Show country only
Hide my location
You can mark text as 'quoted' by putting [quote] .. [/quote] around it.
Please type in the code:

Please do not post inappropriate pictures. Inappropriate pictures include pictures of minors and nudity.
The owner of this web site reserves the right to delete such material.

photo Add a picture: