Maintaining Server Tables

SPD Server tables do not reuse space. When an SQL statement to delete one or more rows from a table is issued, the row is marked deleted and the space is not reused. You must copy the table in order to recapture the space.