Reset Identity Column Value to 1 in SQL Server
To reset identity column
value in SQL server
or change or rest identity column value to 1 in SQL server.
To reset the identity
below is the syntax:
SYNTAX: DBCC CHECKIDENT
(Table_Name, RESEED, New_Reseed_Value)
|
Table_Name
:
Is name of your identity column table.
RESEED :
It specifies that the current identity value should be changed.
New_Reseed_Value
:
Is the new value to use as the current value of the identity column.
For
Example:
DBCC CHECKIDENT ('UserDetails', RESEED, 0)
|
No comments:
Post a Comment