/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 vote253 views1 answer
Get enginge db mysql
SQL
0 vote177 views1 answer
Opensuse status MySQL
SQL
0 vote193 views1 answer
Mysql regex exact match
SQL
0 vote168 views1 answer
Sql gather statistics to increase performance
SQL
0 vote194 views1 answer
Foreign key multiple columns
SQL
11 votes207 views1 answer
Ddl view
SQL
2 votes123 views1 answer
Sql select in list
SQL
0 vote198 views1 answer
Character count sql
SQL
1 vote191 views1 answer
Sql into vs insert into
SQL
6 votes190 views1 answer
SQL insert all columns
SQL