/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

0 vote265 views1 answer
What is between operator
SQL
2 votes264 views1 answer
How to search table name in stored procedure in sql server
SQL
8 votes279 views2 answers
Change name of colum in sql table
SQL
1 vote261 views2 answers
Mysql spring boot application.properties
SQL
0 vote269 views1 answer
Mysql query single row
SQL
0 vote294 views1 answer
Apex for oracle 11g
SQL
0 vote260 views1 answer
Month mysql
SQL
0 vote276 views1 answer
Sql add calculated column
SQL
52 votes478 views6 answers
Rename column sql
SQL
2 votes293 views2 answers
Sql query to list all tables in a database sql server
SQL

Share