Home Forums Article Discussions Article Discussions by Author Discuss content posted by Ben Kubicek What will the max id be? RE: What will the max id be?

  • December 19, 2012 at 7:01 am

    #1570050

    palotaiarpad (12/19/2012)

    I'm also wrong, but i learned something. Could someone please explain, why is the identity resetted after a truncate? For me is a possible source of inconsitency.

    Hello, if resetting the identity is a possible source of inconsistency you may try using DELETE instead of TRUNCATE. DELETE will remove the data without resetting the identity.