Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
PACK DATABASE Command
Collapse the table of content
Expand the table of content

PACK DATABASE Command

Removes records marked for deletion from the current database.


PACK DATABASE

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.

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

Community Additions

ADD
Show:
© 2015 Microsoft