/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 vote369 views1 answer
Select from describe sql
SQL
1 vote448 views1 answer
Mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists.
SQL
2 votes350 views1 answer
Oracle apex who is connected
SQL
2 votes394 views1 answer
Postgresql create table as select
SQL
7 votes410 views2 answers
Sql remove duplicates based on column
SQL
7 votes390 views1 answer
Xampp reset mysql
SQL
0 vote365 views1 answer
Oracle temporary table
SQL
0 vote381 views1 answer
Add timestamp column to existing table t-sql
SQL
3 votes365 views3 answers
Start postgresql ubuntu
SQL
0 vote351 views1 answer
Inner joint
SQL