Re: How to retain "Key" order when Deleting a Row

[Martijn Tonies]

> I just need someone to please point me in the right direction on retaining
> my "key" or id order in my table when I delete a row. So for example I
have
> 10 rows Id 1-10 that are created automatically when the record is
inserted.
>
> So if I delete record with id 5 my id's are not 1,2,3,4,6,7,8,9,10 but
> 1,2,3,4,5,6,7,8,9 ???

It might be me ... but why bother?

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com