SAP Knowledge Base Article - Preview

2996663 - Maximum number of referential constraints in SAP ASE


  • What is the maximum number of referential constraints in ASE?
  • When creating a referential constraint, ASE returns message 1738:

Msg 1738, Level 16, State 2:
Server 'ASE', Line 3:
Creating this referential constraint would result in the total number of referential constraints of table 'table_name' exceeding 192.
Please run: 'sp_helpconstraint table_name' to find out the number of referential constraints that this table has.



SAP Adaptive Server Enterprise (ASE) 15.7 & 16.0


SAP Adaptive Server Enterprise 16.0


KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Product Enhancement

About this page

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

Search for additional results

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