Say I have have deleted some rows in a database.... How do I renumber an auto incremented field...
With which rdms ? With Oracle, use sequences, with MySQL use LAST INSERT ID().