Skip to Content
0

datatype length HANA studio

Dec 29, 2016 at 07:57 AM

41

avatar image

Hi,

is it possible to increase the column length from 2 to 10.

I am getting below error, if I execute this statement. Could anyone pls correct me where I am making mistake?

Thanks in advance!

ALTER TABLE "XXXX"."Cust_Mst" Alter (Middlename Nvarchar(10));
Could not execute 'ALTER TABLE "XXXX"."Cust_Mst" Alter (Middlename Nvarchar(10))'
SAP DBTech JDBC: [260]: invalid column name: MIDDLENAME: line 1 col 40 (at pos 39)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Florian Pfeffer
Dec 30, 2016 at 10:04 AM
0

As the message says, you have specified a wrong column name in your ALTER statement. I assume that your column name is a mix of upper and lower cases. As you do not have enclosed the column name in double quotes the column name is converted to an uppercase name (as printend in the message).

In case your column name is written like "Middlename" enclose it in double quotes in the statement:

ALTER TABLE "XXXX"."Cust_Mst" ALTER ("Middlename" nvarchar(10));

Regards,
Florian

Share
10 |10000 characters needed characters left characters exceeded