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:

Convert a Comma-Delimited List to a Table in SQL
List all Foreign Keys referencing a given table in SQL Server
Return number of rows affected by UPDATE statements in SQL
How to get triggers create and update date in SQL
Post Views: 37

Leave a Reply

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