Reorganizing the primary key numbering sequence. Any way to do that?


I’m using the UNION statement to fusion two different tables into a single table, and the problem is I am getting a mess in my ID (primary key), so I find many registries showing the same number 1,1,1,1,2,2,2,3,3,4,4,4,4,4,4,5,5… and so on…

I’m wondering if do we have any way or method…? perhaps a SQL code… that make a miracle and reorder from 1 to the latest registry, all the registries in the right sequence, 1,2,3,4,5,etc. avoiding duplicate numbers in the primary key.
Any way to solve this?

Any SQL code or method to make the miracle would be greatly appreciated


Hi - This FAQ explains the different scenarios