Reference Manual
   CHAPTER 9. SQL Statements     

CHECKPOINT statement

Function 

To checkpoint the database.

Syntax 

CHECKPOINT

Permissions 

DBA authority is required to checkpoint the network database server.

No permissions are required to checkpoint the personal database server.

Side effects 

None.

Description 

The CHECKPOINT statement checkpoints the database. Checkpoints are also performed automatically by the database server. It is not normally required for an application to ever issue the CHECKPOINT statement.

     For a full description of checkpoints, see Backup and Data Recovery.

Standards and compatibility 

• SQL/92     Vendor extension

• Sybase     Supported by Adaptive Server Enterprise.