/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 vote224 views1 answer
Where date in datetime mysql
SQL
-2 votes204 views1 answer
No module named '_sqlite3
SQL
2 votes193 views2 answers
Oracle multiple insert
SQL
1 vote192 views2 answers
Postgresql remote connect
SQL
0 vote259 views1 answer
Postgres select from values
SQL
0 vote193 views1 answer
Copy Table from SQL to CSV
SQL
1 vote203 views1 answer
Best sql course
SQL
10 votes201 views2 answers
Oracle alter sequence nextval
SQL
0 vote238 views1 answer
Oracle show running job
SQL
0 vote180 views1 answer
View t-sql mail configuration
SQL