As a database designer, I often create on database tables the primary key as identity autoincrement and sometimes I needed to find missing or deleted IDs thet interrupt the sequence of autoincrement number on the primary key. To do this you can create a sequence from 1 (or 0 based on setted RESEED) to MAX […]