Biswajeet Samal's Blog

Sharing My IT Experience

Home

Reset autoincrement to start at 1 in Microsoft SQL Server

Biswajeet April 5, 2015 No Comments on Reset autoincrement to start at 1 in Microsoft SQL Server

Use the following command to reseed YourTableNameHere to start at 1:

DBCC CHECKIDENT (YourTableNameHere, RESEED, 0)

(9 votes, average: 5.00 out of 5)

» How SOQL differs from SQL?

» How to set up Database Mail in SQL Server?

» Creating Job in SQL Server 2008

» How to split a comma delimited string in SQL Server

» Removing hidden CRLF from a string in MS SQL Server

About Biswajeet

Biswajeet is my Name, Success is my Aim and Challenge is my Game. Risk & Riding is my Passion and Hard Work is my Occupation. Love is my Friend, Perfection is my Habit and Smartness is my Style. Smiling is my Hobby, Politeness is my Policy and Confidence is my Power.

View all posts by Biswajeet →

← Salesforce: Use Tab in Visualforce Page Conditional IF Statements in Salesforce Email Template →