Here is the query to reset identity column value
DBCC CHECKIDENT( <TableName> , RESEED, <Values>)
<Table Name> :- Table Name in which you want to reset identity column.
<Values> :- This is value by which you want to increment column value
eg. this may 1 (It increment values by one )
DBCC CHECKIDENT( <TableName> , RESEED, <Values>)
<Table Name> :- Table Name in which you want to reset identity column.
<Values> :- This is value by which you want to increment column value
eg. this may 1 (It increment values by one )
0 comments:
Post a Comment