SAP Knowledge Base Article - Preview

2232787 - How to reset next identity value after jump in the value on a table - SAP ASE


  • After executing shutdown with nowait, some tables with identity columns have huge gaps in identity columns.
  • This article explains how to reset identity gaps accordingly.



SAP Adaptive Server Enterprise (ASE) 15.7 and 16.0


SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0


identity, identity_burn_max, next_identity , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.