/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 vote135 views1 answer
Oracle allow space to user
SQL
1 vote139 views1 answer
How to show index type in postgresql
SQL
0 vote125 views1 answer
Tsql delete all rows
SQL
1 vote132 views1 answer
SQL query to get all table records count from a database
SQL
5 votes127 views1 answer
How to get all dates in a month in oracle
SQL
3 votes126 views4 answers
Truncate syntax in sql
SQL
0 vote132 views1 answer
Vbscript connect mssql
SQL
0 vote134 views1 answer
Const pool = mysql.createpool()
SQL
34 votes154 views6 answers
Install mysql client ubuntu
SQL
0 vote131 views1 answer
Search mysql database for column
SQL