/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

12 votes198 views4 answers
SQL Where
SQL
6 votes190 views2 answers
Mysql version check cmd
SQL
0 vote214 views1 answer
Count characters of string mysql
SQL
0 vote202 views1 answer
Psql get table data types
SQL
22 votes198 views4 answers
Mysql reset auto increment id
SQL
0 vote211 views1 answer
Postpresql relation not found
SQL
0 vote249 views1 answer
Oracle list user locked
SQL
0 vote209 views1 answer
Sql query for select from specific columns in a table
SQL
0 vote303 views3 answers
Fetlife
SQL
0 vote209 views1 answer
Access denied for user 'root'@'localhost' workbench ubuntu
SQL