rearranging id's

Hello, is there an easy way of rearranging id's in a table after deleting one or more entry/entries (other than creating a new tbl and dropping the old one). I appreciate any hint. Thank you. --- Ali Reza Sajedi http://www.bupnet.de/info/mitarbeiter.php3?id

Re: rearranging id's

Ali writes: Hello, is there an easy way of rearranging id's in a table after deleting one or more entry/entries (other than creating a new tbl and dropping the old one). I appreciate any hint. Thank you. Drop the column and recreate it. It really is an incredibly dumb thing to do

Re: rearranging id's

Jari Mäkelä writes: It is easier to have consequential data before starting to make the relations if you are forced to work on fixing up the follies/ages old tables of other people True, true. What I can't understand is why so many people insist on wanting to renumber things continously.