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.

Question:
How can I reset or reseed the IDENTITY column?

Answer:
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

Comments:

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
anonymous  
Hello
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  
rating
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 gadgethacksolution@gmail.com 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: gadgethacksolution@gmail.com he will be glad to help you.
2018-03-20, 08:49:26
anonymous from United States  
2018-07-08, 09:56:24
anonymous  
✅MEET THE REAL HACKERS✅

I Always Feel Bad Whenever we receive complaints from Clients About The Hackers They Met Before They Heard about us.
These Days There Are alot of Hackers Online, You Just Have to Be Careful about who you meet for help, Because Some Of These People Are Scammers Pretending To be Hackers ❌❌❌
You Can Always Identify Them With Their False Write Ups and False Testimonies Trying To Lure you Into their Arms.❌❌❌

✅COMPOSITE HACKS is here to Connect you with The Best Hackers Online So you can get saved from The Arms of the Fake Hackers❌❌

✅We have Legit Hackers and Private investigators at your service. 💻 Every member of our team is well experienced in their various niches with Great Skills, Technical Hacking Strategies And Positive Online Reviews And Recommendations💻🛠

✅We have Digital Forensic Specialists, Certified Ethical Hackers, Computer Engineers, Cyber Security Experts, Private investigators and more on our team. Our Goal is to make your digital life secure, safe and hassle-free.
Some Of The Services we render includes:
* Website hacking 💻
* Facebook and social media hacking 📲
* Database hacking, & Blog Cleaning🛠
* Phone and Gadget Hacking 📲
• CREDIT CARD Loading ( Strictly USA & UK Credit Cards Only) 💳
* Clearing Of Criminal Records ❌
* Location Tracking 📲
and many More

✅We have a team of seasoned PROFESSIONALS under various skillsets when it comes to online hacking services. Our company in fact houses a separate group of specialists who are productively focussed and established authorities in different platforms. They hail from a proven track record Called “HackerOne” and have cracked even the toughest of barriers to intrude and capture or recapture all relevant data needed by our Clients. Some Of These Specialist Includes ⭐️ PETER YAWORSKI ⭐️FRANS ROSEN⭐️ JACK CABLE ⭐️JOBERT ABMA⭐️ ARNE SWINNEN ⭐️And More. All you Need To do is To Write us a Mail Then We’ll Assign any of These Hackers To You Instantly.

Feel Free To Mail Us Anytime 📩

📩 CONTACT:
E-mail: compositehacks@gmail.com
Hire a Hacker!
Want faster service?
Contact us!
HackerOne©️LLC 2018.
All Rights Reserved ®️

★We Treat Every Request With Utmost Confidentiality★

 

 

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: