At 2/7/2001 06:48 AM (Wednesday), Jörg Schiemann wrote:

>Q4. Is that all nonsense?

Mostly it is, but many of us run into it regularly when our clients get too
close to the database design.

If your client really wants a sequence of client ID numbers which can be
re-used I think you should add this column to your table and manage it
within your application. Use a different ID column in the database for
database referential integrity. For this I would recommend a
generator-supplied unique ID.