/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 vote159 views8 answers
Sql to c# linq converter online
SQL
150 votes316 views10 answers
Grepper
SQL
0 vote156 views1 answer
To Create directory
SQL
0 vote132 views1 answer
Stored function in sql
SQL
1 vote139 views1 answer
Oracle turn off constraint
SQL
6 votes139 views6 answers
Code: 'ER_NOT_SUPPORTED_AUTH_MODE', errno: 1251, sqlMessage: 'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004', fatal: true
SQL
5 votes123 views1 answer
Mysql add user with all privileges
SQL
0 vote128 views1 answer
Show database not empty tables postgres
SQL
0 vote134 views1 answer
Enable full text search mysql
SQL
1 vote119 views1 answer
Mysql datetime with timezone offset
SQL