/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 vote343 views1 answer
Difference berween database and data base management system
SQL
1 vote319 views1 answer
Sql how to replace full stop
SQL
-2 votes315 views2 answers
Add auto_increment column to existing table mysql
SQL
0 vote306 views2 answers
Oracle create tablespace autoextend
SQL
3 votes290 views2 answers
To_char oracle
SQL
0 vote301 views1 answer
How to add timestamp column in mysql
SQL
1 vote296 views1 answer
Oracle create as select
SQL
3 votes368 views1 answer
Oracle nextval insert
SQL
1 vote300 views1 answer
How to delete data from sql database in android
SQL
0 vote296 views1 answer
Clear query cache sql server
SQL