/SQL/Reset a table's identity column and remove test records

Reset a table's identity column and remove test records

-- 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)

Source: tutorialsrack.com

Similar codes

0 vote167 views1 answer
What is SQL data store?
SQL
1 vote184 views2 answers
How to install mysql workbench in ubuntu 20.04
SQL
0 vote183 views1 answer
Unable to convert mysql date/time value to system.datetime
SQL
0 vote178 views1 answer
How to join result table in mysql
SQL
5 votes166 views1 answer
Mysql select greater than yesterday
SQL
0 vote173 views1 answer
Install sql server windows 10
SQL
16 votes166 views6 answers
Mysql find and replace
SQL
0 vote194 views2 answers
What is rownum in oracle
SQL
2 votes158 views1 answer
Scaffold npgsql net core
SQL
0 vote172 views1 answer
List all indexes postgres
SQL