Skip to Content
0

Modify column datatype in SAP HANA web-based development catalog

Sep 29, 2017 at 02:52 AM

63

avatar image
Former Member

I'm trying to convert a column named "PRICE" in my table from a double to a decimal, and cant seem to do so.
I've tried these few following codes in the sql console but they don't seem to work, any ideas? Thanks in advance!

ALTER TABLE firsttable.products ALTER COLUMN PRICE DECIMAL(10,2);
ALTER TABLE firsttable.products MODIFY COLUMN price DECIMAL(10,2);<br>ALTER TABLE FIRSTTABLE.PRODUCTS ALTER (PRICE DECIMAL(10,2));
10 |10000 characters needed characters left characters exceeded

From a syntactic point of view the last try is the right one.

What error message do you get?

0
Former Member
Florian Pfeffer

I've forgotten what error message had I got, anyways I've re-created the table as it hasn't been populated yet. Thanks anyways!

0
* Please Login or Register to Answer, Follow or Comment.

0 Answers