Re: rearranging id's

2001-10-31 Thread Carl Troein
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

Re: rearranging id's

2001-10-31 Thread Carl Troein
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, bu