Tuesday, February 14, 2012

sql server reset identity column value

Following sql query will help for reset identity coloumn.

DBCC CHECKIDENT('tablename', RESEED, 0)


"tablename" -- which table you want to reset identity coloumn.

Happy coding...

No comments: