Alter the datatype of hana table filed
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...