SQL Server - reset identity field
sql-server
Solution
Use DBCC CHECKIDENT:
DBCC CHECKIDENT(<tablename>, RESEED, 0);
Problem
I have a table with a identity column. I need to reset that identity column from zero. What should i do for this.
sql-server
Use DBCC CHECKIDENT:
DBCC CHECKIDENT(<tablename>, RESEED, 0);
I have a table with a identity column. I need to reset that identity column from zero. What should i do for this.