/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

5 votes301 views1 answer
Sql first day of current year
SQL
4 votes373 views2 answers
Could not find driver (SQL: SHOW FULL TABLES WHERE table_type = 'BASE TABLE')
SQL
0 vote387 views1 answer
Get substract count sql
SQL
3 votes339 views1 answer
Uppercase and lowercase in sql
SQL
0 vote379 views1 answer
Postgres - Login and connect as default user
SQL
0 vote328 views1 answer
Less than and between in sql query
SQL
0 vote373 views3 answers
Mysql CAST(amount as float)
SQL
2 votes334 views1 answer
Sqlite3 show columns name
SQL
3 votes370 views2 answers
Truncate table
SQL
2 votes327 views1 answer
Mysql create user with mysql_native_password
SQL