Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » Database Options » Introduction to database options » Alphabetical list of options

truncate_timestamp_values option [database] [MobiLink client] Next Page

truncate_with_auto_commit option [database]

Speeds up TRUNCATE TABLE statements.

Allowed values

On, Off




Can be set for the PUBLIC group only. DBA authority required.


If truncate_with_auto_commit is set to On, then a COMMIT is executed both before and after the TRUNCATE TABLE statement is executed. The primary purpose of the option is to enable faster table truncation (delete of all rows).

There are some cases where a fast TRUNCATE cannot be done:

See also