/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

2 votes114 views2 answers
Postgres set user as superuser
SQL
21 votes107 views6 answers
Docker run mysql
SQL
0 vote132 views1 answer
Sql developer format sql
SQL
0 vote101 views1 answer
Wincc 7.4 to sql stackoverflow
SQL
2 votes114 views1 answer
Change primary key sql
SQL
0 vote116 views1 answer
Mysqli_real_connect(): (28000/1045): Access denied for user 'u0738423'@'www8.aname.net' (using password: YES)
SQL
9 votes117 views5 answers
Sql delete duplicate rows but keep one
SQL
1 vote108 views1 answer
Grab all records from one table to another oracle sql
SQL
0 vote116 views1 answer
Mysqli_connect using prepare statement
SQL
2 votes104 views1 answer
Get first 3 letters name in sql
SQL