HDTutorial
EN
How to set Auto Increment to one 1 even after deleting records in SQL Server

Playback starts YouTube’s embedded player (privacy-enhanced mode).

How to set Auto Increment to one 1 even after deleting records in SQL Server

17,092 views November 15, 2019 3:38

Watch on YouTube
ChannelCode Combination

Description from the creator

How to set Auto Increment to one 1 even after deleting records in SQL Server
IMPORTANT NOTE: =========================================== Make sure to delete all the data in the table before entering the line of code. ==============================================
1)Go in your Sql Server database.
2)Select your database.
3)Open your Table whose id you want to reset.
4)Click on Select top 2000 rows.
5)Delete all the data present in your table.
6)In your appeared tab enter the following line.


DBCC CHECKIDENT('tablename',reseed,0)

About this tutorial

Code Combination published this 3:38 video tutorial on November 15, 2019. It has been watched 17,092 times on YouTube.

Duration
3:38
Published
November 15, 2019
Views
17,092
Likes
73

Tags

Share

This tutorial in other languages