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

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