cancel
Showing results for 
Search instead for 
Did you mean: 

Alter the datatype of hana table filed

Former Member
0 Kudos

Hi Everyone,

Declared a filed in hana table as fallows.

"ADDRESSLINE2" NVARCHAR(50) NOT NULL ,

Now I need to change the filed as

"ADDRESSLINE2" NVARCHAR(50) DEFAULT NULL ,


searched for syntax and came across following syntax, but couldn't help me..

ALTER TABLE "NEO_XXx"."Z_OFFICES"."ADDRESSLINE2" ALTER (NVARCHAR(50) NVARCHAR(50) DEFAULT NULL);


Can anyone guide me with proper syntax...


Tq

Accepted Solutions (1)

Accepted Solutions (1)

pfefferf
Active Contributor
0 Kudos

Hello Satish,

you can use following statement:

ALTER TABLE "NEO_XXX"."Z_OFFICES" ALTER ( "ADDRESSLINE2" NVARCHAR(50) NULL DEFAULT NULL);

Best Regards,

Florian

Answers (0)