Breaking News: Grepper is joining You.com. Read the official announcement!

Reset a table's identity column and remove test records

Curious Cat answered on December 29, 2021 Popularity 1/10 Helpfulness 1/10

answer Reset a table's identity column and remove test records

Reset a table's identity column and remove test records

Comment

-- Delete Record From table
DELETE FROM tbl_emp
WHERE id >= 4 ;

DECLARE @NewSeed NUMERIC(10)

-- Get the Last Value from the Table from where
-- You want to restore the Identity Column Value
SELECT @NewSeed = MAX(id)
FROM tbl_emp ;

-- RESEED the IDENTITY column Value
DBCC CHECKIDENT (tbl_emp, RESEED, @NewSeed)

Popularity 1/10 Helpfulness 1/10 Language sql

Source: www.tutorialsrack.com

Tags: identity-column records reset sql

Link to this answer
Share Copy Link