/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 vote119 views1 answer
Sql alternative to max statement
SQL
0 vote124 views1 answer
Createdb with postgresql on ubuntu
SQL
0 vote115 views1 answer
Sql server select record with max id
SQL
6 votes174 views2 answers
Non relational database
SQL
0 vote124 views1 answer
Enable sql server full text indexing
SQL
0 vote171 views1 answer
Radius search with point data in mysql
SQL
1 vote108 views1 answer
Check constraint to check if date greater than todays date
SQL
0 vote111 views1 answer
Default column value in sql same as other column
SQL
0 vote128 views1 answer
Create table as select sql server error
SQL
5 votes108 views1 answer
Mysql select greater than yesterday
SQL