PACK DATABASE Command

MSDN Home

MSDN
MSDN Library
Development Tools and Language…
Visual FoxPro
Visual FoxPro 9.0 SP2
Microsoft Visual FoxPro 9.0 SP…
Reference
Language Reference
Commands

Commands

& Command
&& Command
* Command
? | ?? Command
??? Command
@ ... CLASS Command
@ ... CLEAR Command
@ ... FILL Command
@ ... SCROLL Command
\ | \\ Command
= Command
ACTIVATE MENU Command
ACTIVATE POPUP Command
ACTIVATE SCREEN Command
ACTIVATE WINDOW Command
ADD CLASS Command
ADD TABLE Command
ALTER TABLE - SQL Command
APPEND Command
APPEND FROM ARRAY Command
APPEND FROM Command
APPEND GENERAL Command
APPEND MEMO Command
APPEND PROCEDURES Command
ASSERT Command
AVERAGE Command
BEGIN TRANSACTION Command
BLANK Command
BROWSE Command
BUILD APP Command
BUILD DLL Command
BUILD EXE Command
BUILD MTDLL Command
BUILD PROJECT Command
CALCULATE Command
CANCEL Command
CD | CHDIR Command
CHANGE Command
CLEAR Commands
CLOSE Commands
CLOSE MEMO Command
COMPILE Command
CONTINUE Command
COPY FILE Command
COPY INDEXES Command
COPY MEMO Command
COPY PROCEDURES Command
COPY STRUCTURE Command
COPY STRUCTURE EXTENDED Comman…
COPY TAG Command
COPY TO ARRAY Command
COPY TO Command
COUNT Command
CREATE CLASS Command
CREATE CLASSLIB Command
CREATE COLOR SET Command
CREATE Command
CREATE CONNECTION Command
CREATE CURSOR - SQL Command
CREATE DATABASE Command
CREATE FORM Command
CREATE FROM Command
CREATE LABEL Command
CREATE MENU Command
CREATE PROJECT Command
CREATE QUERY Command
CREATE REPORT - Quick Report C…
CREATE REPORT Command
CREATE SQL VIEW Command
CREATE TABLE - SQL Command
CREATE TRIGGER Command
CREATE VIEW Command
DEACTIVATE MENU Command
DEACTIVATE POPUP Command
DEACTIVATE WINDOW Command
DEBUG Command
DEBUGOUT Command
DECLARE - DLL Command
DECLARE Command
DEFINE BAR Command
DEFINE CLASS Command
DEFINE MENU Command
DEFINE PAD Command
DEFINE POPUP Command
DEFINE WINDOW Command
DELETE - SQL Command
DELETE Command
DELETE CONNECTION Command
DELETE DATABASE Command
DELETE FILE Command
DELETE TAG Command
DELETE TRIGGER Command
DELETE VIEW Command
DIMENSION Command
DIR or DIRECTORY Command
DISPLAY Command
DISPLAY CONNECTIONS Command
DISPLAY DATABASE Command
DISPLAY DLLS Command
DISPLAY FILES Command
DISPLAY MEMORY Command
DISPLAY OBJECTS Command
DISPLAY PROCEDURES Command
DISPLAY STATUS Command
DISPLAY STRUCTURE Command
DISPLAY TABLES Command
DISPLAY VIEWS Command
DO CASE ... ENDCASE Command
DO Command
DO FORM Command
DO WHILE ... ENDDO Command
DOCK Command
DOEVENTS Command
DROP TABLE Command
DROP VIEW Command
EDIT Command
EJECT Command
EJECT PAGE Command
END TRANSACTION Command
ERASE Command
ERROR Command
EXIT Command
EXPORT Command
EXTERNAL Command
FLUSH Command
FOR EACH ... ENDFOR Command
FOR ... ENDFOR Command
FREE TABLE Command
FUNCTION Command
GATHER Command
GETEXPR Command
GO | GOTO Command
HELP Command
HIDE MENU Command
HIDE POPUP Command
HIDE WINDOW Command
IF ... ENDIF Command
INSERT - SQL Command
IMPORT Command
INDEX Command
KEYBOARD Command
LABEL Command
LIST Commands
LIST CONNECTIONS Command
LIST DATABASE Command
LIST DLLS Command
LIST OBJECTS Command
LIST PROCEDURES Command
LIST TABLES Command
LIST VIEWS Command
LOCAL Command
LOCATE Command
LOOP Command
LPARAMETERS Command
MD | MKDIR Command
MENU Command
MODIFY CLASS Command
MODIFY COMMAND Command
MODIFY CONNECTION Command
MODIFY DATABASE Command
MODIFY FILE Command
MODIFY FORM Command
MODIFY GENERAL Command
MODIFY LABEL Command
MODIFY MEMO Command
MODIFY MENU Command
MODIFY PROCEDURE Command
MODIFY PROJECT Command
MODIFY QUERY Command
MODIFY REPORT Command
MODIFY STRUCTURE Command
MODIFY VIEW Command
MODIFY WINDOW Command
MOUSE Command
MOVE POPUP Command
MOVE WINDOW Command
NODEFAULT Command
NOTE Command
ON BAR Command
ON ERROR Command
ON ESCAPE Command
ON EXIT BAR Command
ON EXIT MENU Command
ON EXIT PAD Command
ON EXIT POPUP Command
ON KEY LABEL Command
ON PAD Command
ON PAGE Command
ON SELECTION BAR Command
ON SELECTION MENU Command
ON SELECTION PAD Command
ON SELECTION POPUP Command
ON SHUTDOWN Command
OPEN DATABASE Command
PACK Command
PACK DATABASE Command
PARAMETERS Command
PLAY MACRO Command
POP KEY Command
POP MENU Command
POP POPUP Command
PRINTJOB ... ENDPRINTJOB Comma…
PRIVATE Command
PROCEDURE Command
PUBLIC Command
PUSH KEY Command
PUSH MENU Command
PUSH POPUP Command
QUIT Command
RD | RMDIR Command
READ Command
READ EVENTS Command
RECALL Command
REINDEX Command
RELEASE BAR Command
RELEASE CLASSLIB Command
RELEASE Command
RELEASE LIBRARY Command
RELEASE MENUS Command
RELEASE PAD Command
RELEASE POPUPS Command
RELEASE PROCEDURE Command
RELEASE WINDOWS Command
REMOVE CLASS Command
REMOVE TABLE Command
RENAME CLASS Command
RENAME Command
RENAME CONNECTION Command
RENAME TABLE Command
RENAME VIEW Command
REPLACE Command
REPLACE FROM ARRAY Command
REPORT FORM Command
RESTORE FROM Command
RESTORE MACROS Command
RESTORE SCREEN Command
RESTORE WINDOW Command
RESUME Command
RETRY Command
RETURN Command
ROLLBACK Command
RUN | ! Command
SAVE MACROS Command
SAVE SCREEN Command
SAVE TO Command
SAVE WINDOWS Command
SCAN ... ENDSCAN Command
SCATTER Command
SCROLL Command
SEEK Command
SELECT - SQL Command
SELECT Command
SET Command Overview
SHOW MENU Command
SHOW POPUP Command
SHOW WINDOW Command
SIZE POPUP Command
SIZE WINDOW Command
SKIP Command
SORT Command
STORE Command
SUM Command
SUSPEND Command
TEXT ... ENDTEXT Command
TOTAL Command
TRY...CATCH...FINALLY Command
TYPE Command
UNLOCK Command
UPDATE - SQL Command
USE Command
VALIDATE DATABASE Command
WAIT Command
WITH ... ENDWITH Command
ZAP Command
ZOOM WINDOW Command

Switch View :

ScriptFree

Visual FoxPro 9.0 SP2

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

Reference

CLOSE Commands
DELETE DATABASE Command
MODIFY DATABASE Command
OPEN DATABASE Command
SET DATABASE Command
VALIDATE DATABASE Command

Other Resources

Commands (Visual FoxPro)