/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 vote200 views1 answer
Sql gather statistics to increase performance
SQL
0 vote174 views1 answer
Mysql shell set time_zone
SQL
11 votes190 views3 answers
Sql line numbers
SQL
1 vote185 views1 answer
Select dba users oracle
SQL
7 votes181 views1 answer
Mysql remote connection command line
SQL
0 vote191 views1 answer
Restart sql server command line linux
SQL
0 vote174 views3 answers
How to modify alter user root@localhost identified with mysql_native_password by properly
SQL
7 votes177 views4 answers
Mysql delete older duplicates
SQL
1 vote184 views1 answer
How to delete a record from sqlite in android
SQL
0 vote184 views1 answer
Delete record by id sql
SQL