Reset identity

  • Identity property in MSSQL server auto increment column value.
  • When we remove rows identity column continues with incerment value, but sometimes we need reset identity to predefined value.
  • We have three choices:
    2. Drop and Add the column
    3. Drop and Create the table
DBCC CHECKIDENT ( <table name>,RESEED,<new value>)
programming/mssql/resetidentity.txt · Last modified: 2018-06-21 19:48 (external edit)
CC Attribution-Noncommercial-Share Alike 4.0 International
Driven by DokuWiki Recent changes RSS feed Valid CSS Valid XHTML 1.0