Reset Identity in SQL Server

For reseting a table identity, there is a way

DBCC CHECKIDENT('dbo.tbl_Sections', RESEED, 0)

first parameter pass table name

third parameter set new starting id. if u want start with 100, then pass third parameter 100.

Advertisements