/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

3 votes344 views1 answer
Select database in sql
SQL
11 votes345 views3 answers
Change column name sql server management studio
SQL
2 votes379 views2 answers
Asp.net core with postgresql deploy on ubuntu
SQL
3 votes335 views1 answer
Oracle apex call duration
SQL
0 vote379 views1 answer
Add user mysql wordpress
SQL
1 vote323 views1 answer
Check message id sql server
SQL
1 vote345 views1 answer
Size of all tables in a schema oracle
SQL
6 votes367 views3 answers
Mysql remove user privileges
SQL
0 vote330 views1 answer
Kotlin sqlite delete row
SQL
1 vote311 views2 answers
Mysql SELECT
SQL