How to change the datatype of a column

[sreelatha_reddy2]

Hi,

I have created 3 tables and created a analytical view using those tables. When I am activating the view , I faced errors saying that a field is incompatible.

[SaiKrishna_V]

Hi Shreelatha,

if you want to change the data type of a column in a HANA table

please use below syntax:

alter table "schema"."table"("columnname" newdatatype)

ex: alter table "SAP"."customer"("cust_id" INTEGER)

regards,

sai Krishna.

[Former Member]

Hi Sreelatha,

Can you check the datatype of Region_id as Varchar instead of NVARCHAR. Please share the snippet of your join data type for more analysis.

Note: SAP recommends only using VARCHAR with ASCII characters based strings. If the data you wish to store contains characters other than ASCII characters, SAP recommends using NVARCHAR data type instead.

The TINYINT data type stores an 8-bit unsigned integer. The minimum value is 0 and the maximum value is 255 for TINYINT.

Regards,

Kannan