/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 vote231 views2 answers
Check if word is in column sql
SQL
0 vote218 views1 answer
How to find username and password in oracle 18c
SQL
11 votes225 views6 answers
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
SQL
0 vote213 views1 answer
Select all same column value in sql
SQL
2 votes237 views1 answer
How to delete columns in sql
SQL
4 votes213 views2 answers
Sql vs mysql
SQL
0 vote251 views1 answer
Parent and child link in mysql
SQL
1 vote235 views1 answer
Mysql workbench in ubuntu 14.04
SQL
6 votes208 views1 answer
What is where clause in sql
SQL
0 vote202 views1 answer
What is the essence of SQL?
SQL