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

SQL Anywhere 17 » SQL Anywhere - Changes and Upgrading » How to upgrade to the latest version of SQL Anywhere » SQL Anywhere Server upgrades » The rebuild process for version 10 and later databases

Reloading tables with AUTOINCREMENT columns

You can retain the next available value for AUTOINCREMENT columns in the rebuilt database by specifying the dbunload -l option. This option adds calls to the sa_reset_identity system procedure to the generated reload.sql script for each table that contains an AUTOINCREMENT value, preserving the current value of SYSTABCOL.max_identity.