SAP Knowledge Base Article - Preview

2406065 - alter table with nodatacopy returns Msg 264 when inserting table - SAP ASE


  1. A reorg rebuild is executed, followed by an alter table drop column with no datacopy.
  2. Then, when an INSERT command is run on a table that has a trigger on the insert, the following error is returned:

    264 error, “Column name <col_name> appears more than once in the result column list.”



SAP Adaptive Server Enterprise (ASE) 15.7 SMP SP134


SAP Adaptive Server Enterprise 15.7


alter nodatacopy,  Msg 264 , reorg rebuild , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

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.