Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Alter the datatype of hana table filed

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

Tags:
replied

Hello Satish,

you can use following statement:

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

Best Regards,

Florian

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question