on 09-30-2015 5:48 AM
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
Hello Satish,
you can use following statement:
ALTER TABLE "NEO_XXX"."Z_OFFICES" ALTER ( "ADDRESSLINE2" NVARCHAR(50) NULL DEFAULT NULL);
Best Regards,
Florian
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.