/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 vote274 views1 answer
Sql how to duplicate a table
SQL
0 vote271 views1 answer
Oracle show running job
SQL
0 vote233 views1 answer
Oracle list all stored procedures
SQL
0 vote267 views1 answer
Hw to delete a procedure in pl sql
SQL
3 votes272 views1 answer
Sql server version query
SQL
1 vote267 views1 answer
Get the User Name and Domain Name from an Email Address
SQL
0 vote279 views1 answer
Select insert new table sql server
SQL
14 votes281 views3 answers
This is incompatible with sql_mode=only_full_group_by laravel
SQL
0 vote258 views1 answer
Oracle drop default value
SQL
0 vote269 views1 answer
How to find username and password in oracle 18c
SQL