SAP Knowledge Base Article - Preview

3208583 - ddlgen generates DDLs including create index statements for a proxy table - SAP ASE


  • When you run ddlgen command for a proxy table, ddlgen command generates not only create existing table statement but also create index statements.
  • You will see a 1902 error, a 1913 error or another error when creating the indexes on the proxy table by using the generated script.

    Msg 1902, Level 16, State 1:
    Server 'ASE16', Line 2:
    Cannot create more than one clustered index on table '<proxy table name>'. Drop the existing clustered index '<proxy table name>' before creating another.

    Msg 1913, Level 16, State 1:
    Server 'ASE16', Line 2:
    There is already an index on table '<proxy table name>' named '<proxy table name>'



SAP Adaptive Server Enterprise (ASE) 16.0


SAP Adaptive Server Enterprise 16.0


705198, CR705198, CR#705198 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

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.