SQL Query For Reset Table Identity

This is SQL Query for resetting Table Indentity :

DBCC CHECKIDENT ([Table_Name], reseed, Reset_Number_To)

place your Table Name in [Table_Name] and replace Reset_Number_To with number you want to start the identity for the next record, for example if you want your identity number start from 1, you replace Reset_Number_To with 0

Leave a Reply

Your email address will not be published. Required fields are marked *


This site uses Akismet to reduce spam. Learn how your comment data is processed.