Id of first record start with 3 instead of 1. RRS feed

  • Question

  • User-815045061 posted

    how to fix it??? will truncate table fix the problem??

    Thursday, December 24, 2015 11:27 AM


  • User753101303 posted


    Yes or you could use https://msdn.microsoft.com/en-us/library/ms176057%28v=sql.120%29.aspx

    If you created two rows and deleted them this is the expected behavior ie an identity value is never reused (else if someone talks about the row with id #1 you are not 100% if he talks about the row #1 you had previously and that may have been deleted since then or the one you created again with the same id).

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, December 24, 2015 1:35 PM