/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 vote56 views1 answer
What are the advantages of MySQL when compared with Oracle?
SQL
0 vote67 views1 answer
Database traccar
SQL
0 vote57 views2 answers
Sql server select where date
SQL
5 votes66 views3 answers
Oracle first day of last year
SQL
0 vote63 views1 answer
Sql server select record with max id
SQL
7 votes72 views1 answer
Return insert results in POSTGRESQL
SQL
0 vote59 views1 answer
Wincc 7.4 to sql stackoverflow
SQL
0 vote84 views1 answer
Mysql default tls v1.3 ciphersuites
SQL
4 votes66 views3 answers
Sqlite show columns
SQL
1 vote62 views1 answer
What is intersect
SQL