1total entries in table
Reset an identity column of a table in SQL Server
Syntax
| DBCC CHECKIDENT (<table>, RESEED, <value>) |
| Option | Description |
|---|---|
| table | The name of the table to be reset. |
| value | The new value to be used. |
| DBCC CHECKIDENT (<table>, RESEED, <value>) |
| Option | Description |
|---|---|
| table | The name of the table to be reset. |
| value | The new value to be used. |