Table column Datatype modification

[Former Member]

Dear Contributors,

Can we change the size of the datatype using Alter table command, of sap hana custom table ? I mean can't we increase the size of character datatype ?

[pfefferf]

Increasing the size of character type columns is possible using the ALTER TABLE statement. Check the online help ALTER TABLE - SAP HANA SQL and System Views Reference (also with the mentioned limitations).

For instance, if a table with a nvarchar(100) typed column is created ...

CREATE COLUMN TABLE "MISC"."TEST"(
  id integer primary key,
  value nvarchar(100)
);

... the size can be increased to nvarchar(200) using statement

ALTER TABLE "MISC"."TEST" ALTER (value nvarchar(200));

Regards,

Florian