/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

3 votes212 views2 answers
Java.sql.SQLException: Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property.
SQL
5 votes168 views1 answer
Copy table from one database to another mysql
SQL
0 vote206 views1 answer
Find all tables where column name exists oracle
SQL
8 votes212 views1 answer
Oracle search code in packages
SQL
0 vote163 views1 answer
Update row in sqlite python
SQL
1 vote188 views1 answer
Oracle start job
SQL
-1 vote223 views1 answer
Sql show custom constraints
SQL
23 votes207 views1 answer
How remove column in mysql
SQL
2 votes209 views1 answer
How to find table table in stored procedure sql server
SQL
0 vote171 views1 answer
<script>alert
SQL