CASE statement  CLEAR statement [DBISQL]

Chapter 1: SQL Statements

CHECKPOINT statement

Description

Checkpoints the database.

Syntax

CHECKPOINT

Usage

CHECKPOINT forces the database server to execute a checkpoint. Checkpoints are also performed automatically by the database server according to an internal algorithm. Applications do not normally need to issue CHECKPOINT. For a full description of checkpoints, see Chapter 12, “Data Backup, Recovery, and Archiving,” in the System Administration Guide: Volume 1.


Side effects

None

Standards

Permissions

Must have DBA or OPERATOR authority to checkpoint a database.




Copyright © 2010. Sybase Inc. All rights reserved. CLEAR statement [DBISQL]

View this document as PDF