/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

1 vote187 views2 answers
Replace text in sql
SQL
0 vote190 views1 answer
Update if else mysql
SQL
0 vote198 views1 answer
Creation d'un trigger sql
SQL
0 vote183 views1 answer
Delete double on SQL with multiple primary keys
SQL
0 vote183 views1 answer
Shell script to log mysql cpu usage
SQL
0 vote216 views2 answers
Wordpress change url after migration mysql query
SQL
0 vote186 views1 answer
Sql server select top 2 of each group
SQL
0 vote193 views1 answer
Uuid sqlalcomany
SQL
0 vote214 views1 answer
Mysql bind-address default value
SQL
0 vote203 views1 answer
Manage Database in MySQL
SQL

Share