/SQL/Reset identity column values in sql server

Reset identity column values in sql server

Sql server reset identity

	DBCC CHECKIDENT ('table name', RESEED , 0)

8

Reset identity column in sql server

DBCC CHECKIDENT ('YourTableName', RESEED, 1)

2

Reset identity column values in sql server

/*If you have delete all the rows in a table, and you want to reset the identity column value, use this*/
DBCC CHECKIDENT ('Table_Name',RESEED,0)

1

How to reset the identity column in sql server

USE <databasename>;  
GO  
DBCC CHECKIDENT ('<tablename>.<columnname>', <value>, <incrementby>);  
GO

0

Similar codes

1 vote196 views1 answer
Alter table column size oracle
SQL
-3 votes197 views2 answers
How to enable mysql authentication on ubuntu 18.04
SQL
1 vote245 views1 answer
Mysql return text after a final full stop
SQL
22 votes312 views4 answers
Tsql rename table
SQL
0 vote209 views1 answer
How to use group_concat in sql server
SQL
0 vote199 views1 answer
Oracle call a function in a insert statement
SQL
13 votes204 views5 answers
Oracle list tables
SQL
0 vote208 views1 answer
Mysql update from n to 100
SQL
0 vote215 views1 answer
Get substract count sql
SQL
14 votes196 views4 answers
Remove record from table sql
SQL

Share