/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

1 vote399 views1 answer
Postgresql if 0 then 1
SQL
1 vote367 views1 answer
Store select query result in variable sql server
SQL
1 vote379 views1 answer
Pl sql create table from another table
SQL
0 vote357 views1 answer
Normalization in database 2nd normal form
SQL
0 vote453 views1 answer
Drop table BigQuery table columns
SQL
0 vote362 views1 answer
Oracle query to find schema you are working on
SQL
10 votes396 views4 answers
Mysql if else
SQL
5 votes349 views1 answer
Oracle get foreign keys on table
SQL
0 vote392 views1 answer
Acutal month year
SQL
3 votes386 views1 answer
Postgres select max value
SQL