Let's start with - you NEVER renumber a primary key. Period!!! All hail rule #1 from all mighty @Pat Hartman It is good to follow this rule :)