/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 vote189 views1 answer
Mssql + bit + in python orm
SQL
0 vote167 views1 answer
Oracle list proxy users
SQL
0 vote173 views1 answer
Sql counter column
SQL
0 vote177 views1 answer
Insert array into mysql column
SQL
5 votes239 views1 answer
Mysql last day of next month
SQL
13 votes164 views2 answers
Check if value is null mysql
SQL
11 votes178 views1 answer
Creating tables in sql with python
SQL
1 vote176 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception table not found
SQL
1 vote212 views2 answers
Mysql limit offset
SQL
9 votes170 views3 answers
Mysql get last id
SQL