Reset the Identity on table in MSSQL – Bits of .NET

SQL

Reset the Identity on table in MSSQL

- 08.04.20 - ErcanOPAK

DBCC CHECKIDENT('TableName', RESEED, 0)

Note that after running DBCC CHECKIDENT('TableName', RESEED, 0):
– Newly created tables will start with identity 0
– Existing tables will continue with identity 1

Related posts:

SQL: Use Window Functions for Running Totals and Ranking

SQL Tables Age Worse Than Code

SQL “Slow LIKE Query” — The Real Fix (Not Indexes!)

Post Views: 54

Leave a Reply Cancel reply