/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 vote284 views1 answer
Sql server is not
SQL
1 vote297 views4 answers
Postgres extract date from timestamp
SQL
2 votes314 views1 answer
Q operator in sql
SQL
0 vote311 views1 answer
The report definition has an invalid target namespace 'http://schemas.microsoft.com/SQLServer/reporting/reportdesigner'
SQL
0 vote299 views1 answer
Character count sql
SQL
0 vote311 views1 answer
Find duplicate users by email address in mysql
SQL
3 votes298 views1 answer
Select table column in sql
SQL
10 votes298 views1 answer
Query to find object dependencies in oracle
SQL
8 votes316 views2 answers
Replace string value in sql
SQL
20 votes308 views1 answer
Sql change column types
SQL