toles

was wondering if there is an easy way to splice id fields in such a way that if you have the fields:

ID
1
2
3
4
5

and you remove field 2, then 3,4 and 5 would become 2,3, and 4. In other words:

ID >> ID
1 >> 1
2 >> 2
3 >> 3
4 >> 4
5 >>

If you remove '2' from the first.

Thankyou for your help.

BigDaddy71

No easy way to do that, you'd have to write code that alters the ID yourself. Any reason why you need to do this?

msalerno

We need more of the use case to be able to help.

- What are you storing in the tables
- Is the data you're going to modify used as primary keys against multiple tables (ie: if you do the shuffle you are suggesting, will your references in other tables also break)
- Is it an auto incrementing column that you are working on?

-mjs