Purpose

Ensures that all database changes in memory are committed to disk. Executing the Checkpoint statement closes the database files, rewrites the script file, deletes the log file, and reopens the database.

Syntax

CHECKPOINT [DEFRAG]

where:

DEFRAG
if specified, this statement evaluates abandoned space in the database data file (.data) and shrinks the data file to its minimum size.