/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 vote247 views1 answer
How to read the potentail error messages in ssis package
SQL
0 vote232 views1 answer
Acual month sql
SQL
1 vote240 views1 answer
Mysql select if empty result
SQL
2 votes251 views1 answer
Where clause for child record apex
SQL
0 vote245 views1 answer
Logtash mysql cofiguration file
SQL
0 vote289 views1 answer
Postgres docs /copy metacomand
SQL
2 votes258 views1 answer
Sql find not in list
SQL
0 vote230 views1 answer
Oracle date summer time
SQL
0 vote253 views2 answers
Mysql where in maintain order group_concat
SQL
5 votes261 views1 answer
Oracle add time to date
SQL