Syntax:
      DBCC CHECKIDENT 
        ( 'table'
                [ , { NORESEED | { RESEED [ , new_reseed_value ] } } ]
        ) [WITH NO_INFOMSGS]
 Key:
   NORESEED     -  The current identity value should not be changed.
   RESEED       -  Change the identity value.
   new_reseed_value - The new seed value to be used for the identity column.
   WITH NO_INFOMSGS - Suppresses all information messages.
DBCC CHECKIDENT ('Employee', RESEED, 0)
 
 
No comments:
Post a Comment