• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1815
  • Last Modified:

Deleting Pervasive SQL Records

I am using an ODBC connection to a Pervasive SQL table.  I use a SQL statement to delete certain records from the table.  When I a finished the records are deleting correctly but the table is now twice the size as it was before.  Is there some utility or command that should be run after deleting records to reclaim space in the table?
1 Solution
Actually, the space will be reclaimed as new records are added.  If you need the space back sooner, you can use the Rebuild Utility or BUTIL.  Using BUTIL, you would CLONE then COPY the data.  Rebuild works on the actual file so you'd want everyone out of the system when you do it.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now