Modify column datatype in SAP HANA web-based development catalog

[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));

[pfefferf]

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

What error message do you get?

[Former Member]

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!