PACK DATABASE Command

Removes records marked for deletion from the current database.

PACK DATABASE

Remarks

A database contains records marked for deletion after a table or view is removed from the database, or if the structure of a table in the database is modified.

The database must be opened exclusively, and no table or view in the database can be open.

Example

In the following example, PACKDATABASE is used to pack the testdata database, removing records marked for deletion.

CLOSE DATABASES
SET PATH TO (HOME(2) + 'data\')     && Sets path to database
OPEN DATABASE testdata  && Open the database
PACK DATABASE && Pack the current database

See Also

Reference

CLOSE Commands

DELETE DATABASE Command

MODIFY DATABASE Command

OPEN DATABASE Command

SET DATABASE Command

VALIDATE DATABASE Command

Other Resources

Commands (Visual FoxPro)