posts - 5 , comments - 1 , trackbacks - 0

Reset Identity column in SQL table

To reset Identity from 1

Below would reset identity column of SQL table and start Identity column value from 1

DBCC CHECKIDENT (TABLE_NAME, reseed, 0)


To reset Identity from the specified value 

Say, If records are already deleted (from 31 to the end record ) and if user would like to create record from 31 then below will work

DBCC CHECKIDENT (TABLE_NAME, reseed, 30)

– Karthick Raju

Print | posted on Friday, November 4, 2016 6:44 AM | Filed Under [ SQL SQL Server ]

Feedback

Gravatar

# re: Reset Identity column in SQL table Rout de lecol N 13 Zaatra Boumerdes algeria

نستمع حتى نتجاوز خطاب ونضع نصب أعيننا حقائق علميه
1/6/2018 2:27 PM | Youcef Benchouk
Post A Comment
Title:
Name:
Email:
Comment:
Verification:
 

Powered by: