Skip to Content
avatar image
Former Member

Modify column datatype in SAP HANA web-based development catalog

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));
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers