When executing a ALTER TABLE ... RENAME statement to rename a or column with the same name but with different capitalization, you get this error:
ALTER TABLE TEST RENAME Test;
Could not execute statement.
Item 'Test' already exists
SQLCODE=-110, ODBC 3 State="42S01"
Line 3, column 1
- SAP IQ 16
- SAP IQ 15.x
case-sensitive , KBA , BC-SYB-IQ , Sybase IQ , Problem
About this pageThis 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.