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: : invalid column name: <COLUMN_NAME>: line 1 col 38 (at pos 37)
Could not execute 'ALTER TABLE "<SCHEMA_NAME>"."TABLE_NAME" DROP COLUMN (<COLUMN_NAME>)'
SAP DBTech JDBC: : sql syntax error: incorrect syntax near "COLUMN": line 1 col 37 (at pos 37)
SAP HANA Database 1.0
SAP HANA Database 2.0
DROP COLUMN , KBA , HAN-DB , SAP HANA Database , Problem
About this pageThis 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.