Symptom
You wish to drop a column from a HANA table and you receive an error similar to the following:
Could not execute 'ALTER TABLE "<SCHEMA_NAME>"."TABLE_NAME" DROP (<COLUMN_NAME>)'
SAP DBTech JDBC: [260]: invalid column name: <COLUMN_NAME>: line 1 col 38 (at pos 37)
OR
Could not execute 'ALTER TABLE "<SCHEMA_NAME>"."TABLE_NAME" DROP COLUMN (<COLUMN_NAME>)'
SAP DBTech JDBC: [257]: sql syntax error: incorrect syntax near "COLUMN": line 1 col 37 (at pos 37)
Read more...
Environment
SAP HANA Database 1.0
SAP HANA Database 2.0
Product
Keywords
DROP COLUMN , KBA , HAN-DB , SAP HANA Database , 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.