Database Error Messages

Release
toggle
  • 23ai
Updated
Jun 24, 2024

CPY-00006

Select list has more columns than destination table

Cause

On an APPEND operation or an INSERT (when the table exists), the number of columns in the SELECT command is greater than the number of columns in the destination table.


Action

Re-specify the COPY command, making sure that the number of columns being selected agrees with the number in the destination table.