Export (0) Print
Expand All
Expand Minimize

PACK DATABASE Command

Visual Studio .NET 2003

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, PACK DATABASE 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

CLOSE DATABASES | DELETE DATABASE | MODIFY DATABASE | OPEN DATABASE | SET DATABASE | VALIDATE DATABASE

Show:
© 2014 Microsoft