/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 vote198 views1 answer
Oracle session statistics
SQL
8 votes180 views1 answer
Alter tablespace add datafile
SQL
1 vote206 views1 answer
Mysql not supported auth mode
SQL
0 vote187 views2 answers
How to update date in oracle
SQL
0 vote193 views1 answer
Sql server set complex constraints
SQL
10 votes197 views4 answers
SELECT FROM WHERE
SQL
1 vote193 views1 answer
GROUP BY clause; this is incompati
SQL
10 votes290 views2 answers
Doublon sql
SQL
1 vote215 views1 answer
Select inside insert query
SQL
0 vote194 views1 answer
Oracle archivemode
SQL