/SQL/Reset identity column in sql server

Reset identity column in sql server

Sql server reset identity

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

4

SQL Server reset ID

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

1

Source: stackoverflow.com

Reset identity column in sql server

DBCC CHECKIDENT ('YourTableName', RESEED, 1)

1

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

Reseed sql table primary key

DBCC CHECKIDENT ('YourTableName', RESEED, 1)

0

Source: programmertunnel.com

How to reset the identity column in sql server

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

0

Similar codes

13 votes140 views2 answers
Oracle inner join
SQL
0 vote113 views1 answer
Codeigniter 3 get best-selling products
SQL
2 votes120 views2 answers
How to add not null constraint in sql
SQL
0 vote118 views1 answer
Mysql, how to query the table comments?
SQL
1 vote125 views1 answer
Vagrant mysql downgrade version
SQL
2 votes107 views1 answer
Oracle sql drop table purge
SQL
0 vote120 views1 answer
How to write triggers to increment or decrement the number of employees
SQL
12 votes111 views3 answers
Install sqlite driver ubuntu
SQL
13 votes167 views4 answers
Mysql remove foreign key constraint
SQL
2 votes117 views1 answer
Sql server case sensitive search
SQL

Share