SAP Knowledge Base Article - Preview

2691671 - ALTER TABLE DROP COLUMN Command is not Working

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

SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0

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.