Click here to Skip to main content
15,880,796 members
Search within:


How to reset idenitity column in SQL server 2017
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
SQL-Server
i want my id back to 0 after deleting all the records

What I have tried:

Newbie here, I'm not really good using about Sql server but can show me step by step?
Posted
Updated 11-Jul-18 18:03pm
Add a Solution

1 solution

Here is an example to reset the new identity to start from 1
SQL
DBCC CHECKIDENT ('TableName', RESEED, 1)

https://www.c-sharpcorner.com/blogs/how-to-reset-identity-column-values-in-sql-server1

DBCC CHECKIDENT (Transact-SQL) | Microsoft Docs[^]
 
Share this answer
 
Posted
Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month
Related Questions
What data type must used for column date [datelogged] that obtain and preserve time 12 hours on SQL server 2017?
Reset Primary Key in sql server
identity seed reset in sql server
Adding users from visual studio 2017 windows forms to SQL server management studio
How to reset identity specification in sql server
Resetting an Identity column error
Ensure that 782 version of a SQL server express localdb 2014 (.mdf) is respected when importing it into visual studio 2017
Header on excel file changed when export data to from SQL server 2017 to excel ?
Sql - pass columns to rows
reset default value and autoincrement primary key in sql server table

Advertise
Privacy
Cookies
Terms of Use
Last Updated 12 Jul 2018
Layout: fixed | fluid
Copyright © CodeProject, 1999-2024
All Rights Reserved.

Web03 2.8:2024-04-02:1

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900