/SQL/Sql server reset identity

Sql server reset identity

Sql server reset identity

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

6

SQL Server reset ID

DBCC CHECKIDENT ('[TestTable]', RESEED, 0);
GO

2

Source: stackoverflow.com

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 vote218 views2 answers
Clauses in mysql
SQL
4 votes188 views1 answer
Restart for pg_hba.conf file
SQL
0 vote177 views1 answer
Get records in sql according to month name and count
SQL
2 votes224 views2 answers
How to check data type in sql server
SQL
6 votes235 views2 answers
WHERE value IS sql
SQL
0 vote186 views1 answer
ORA-13717
SQL
3 votes189 views3 answers
Raw select laravel
SQL
0 vote236 views2 answers
Dbms interview questions
SQL
3 votes192 views1 answer
Async await mysql nodejs
SQL
0 vote187 views1 answer
Import big data to mysql
SQL

Share