DELETE FROM TABLENAME
DBCC CHECKIDENT ('DATABASENAME.dbo.TABLENAME', RESEED, 0)
Note that this isn’t probably what you’d want if you have millions+ of records, as it’s very slow.
DELETE FROM TABLENAME
DBCC CHECKIDENT ('DATABASENAME.dbo.TABLENAME', RESEED, 0)
Note that this isn’t probably what you’d want if you have millions+ of records, as it’s very slow.