Skip to content

Mike Colbert Online

http://www.mikecolbertonline.com

  • Sample Page
  • Sample Page
  • Risk

Reset Identity Seed in Microsoft SQL

April 22, 2015 by Mike

After you delete records from a table, if you want to set the Identity Seed back to zero:


DBCC CHECKIDENT('msci3025_f14.dbo.msci3025_surveyData', RESEED, 0)
Categories Microsoft SQL
Post navigation
Delete all rows from a Microsoft SQL table
Split first and last names in Excel VBA
  • Cisco
  • Digital Photo
  • Excel VBA
  • Flask
  • HTML & CSS
  • IoT
  • Java
  • Linux
  • Microsoft Azure
  • Microsoft SQL
  • MySQL
  • Oracle SQL
  • Python
  • Security
  • SQLAlchemy
  • Uncategorized
  • Wordpress
  • April 2020
  • November 2019
  • April 2019
  • December 2018
  • October 2018
  • August 2018
  • July 2018
  • March 2018
  • September 2017
  • March 2017
  • February 2017
  • November 2016
  • October 2016
  • July 2016
  • March 2016
  • February 2016
  • January 2016
  • December 2015
  • September 2015
  • June 2015
  • May 2015
  • April 2015
  • January 2015
Log in
Log in
© 2023 Mike Colbert Online • Built with GeneratePress