How to Rename Table / Column in HANA Database

In this article, we are going to show you on how do we perform the table and column rename in SAP HANA database. The whole exercise was executed using the HANA Studio.

Rename Table in HANA

The statement below will rename the table in HANA database.

 
  RENAME TABLE "SAPABAP1"."DEMO" To "AYAM_PENYET";

  Statement 'Rename Table "SAPABAP1"."DEMO" To "AYAM_PENYET"' 
  successfully executed in 59 ms 722 µs  (server processing time: 4 ms 
  207 µs) - Rows Affected: 0

Rename a Table Column in HANA

The statement below will rename the table column in HANA database.

 
  RENAME COLUMN SAPABAP1."AYAM_PENYET"."ACCESSKEY" TO "KUNCI"

  Statement 'RENAME COLUMN SAPABAP1."AYAM_PENYET"."ACCESSKEY" TO 
  "KUNCI"' successfully executed in 58 ms 380 µs  (server processing 
  time: 4 ms 398 µs) - Rows Affected: 0