SAP Knowledge Base Article - Preview

1958443 - CREATE TABLE command succeeds, but returns "Warning: Row size ... could exceed row size limit" or fails with ASE error 1701 even when the row size is within the limit stated in the message -- SAP ASE


  • When attempting to create a table using wide columns, the command returns a warning message even when specifying a size within the stated limit indicated in the message.
  • For example:
    1> create table mywide (a varchar(1961))
    2> go
    Warning: Row size (1975 bytes) could exceed row size limit, which is 1962 bytes.
  • Why the discrepancy in the width reported? How can one determine the maximum allowable column width for a given column type?



SAP Adaptive Server Enterprise 12.5.x and greater


SAP Adaptive Server Enterprise all versions ; Sybase Adaptive Server Enterprise all versions


Error 1701,create table , 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.