/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 vote201 views3 answers
How to create a table structure from another table in mysql
SQL
0 vote241 views1 answer
InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
SQL
0 vote170 views1 answer
Compare if is null sql
SQL
0 vote177 views2 answers
How to use aggregate functions in sql
SQL
0 vote168 views1 answer
Leftjoin in sql
SQL
0 vote162 views1 answer
Oracle list dblink
SQL
5 votes165 views4 answers
Sql check
SQL
0 vote133 views1 answer
Bigquery information_schema schema all columns
SQL
58 votes313 views6 answers
Create new user in postgres
SQL
0 vote180 views1 answer
Remove transient options sql wordpress
SQL