Re: Compressing table after DELETE ?? - Thanks for help

In article <1993Jan24.224220.1_at_jaguar.uofs.edu> littlec1_at_jaguar.uofs.edu (Chris Little) writes:
>
>I have a table with a column of type number. This column is a form of
>keying mechanism, in that the keys are the row numbers. That is, rows
>1 through 10 have keys 1 through 10. I always want this to be the case.
>
>Two questions:
>
>1: How do I maintain this after deleting a single row with a
> single DELETE statement?
>
>2: How do I maintain this after deleting multiple rows with a
> single DELETE statement?

In either case you should renumber the rows after the delete but within the same transaction.

        -chaz Received on Thu Jan 28 1993 - 20:56:20 CET