/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 vote191 views1 answer
Equi joins in oracle
SQL
0 vote194 views1 answer
Mariadb current date plus 1 day
SQL
1 vote338 views1 answer
Sql injection
SQL
0 vote244 views1 answer
Update database collation in postgresql
SQL
9 votes196 views4 answers
How to alter table column name in mysql
SQL
0 vote294 views1 answer
Show mysql account privilleges
SQL
0 vote206 views1 answer
Insert or update sql firebird
SQL
0 vote274 views1 answer
How to add auto increment primary key
SQL
3 votes202 views3 answers
Mysql select table names
SQL
0 vote192 views1 answer
Version and edition of SQL Server Database Engine
SQL