How to change existing column type of a table in Sybase?

Question

I searched for a while and can't get an answer. Why this doesn't work? ALTER TABLE mytable ALTER COLUMN price DOUBLE

Accepted Answer

The syntax is incorrect and there is no DOUBLE datatype in Sybase.

So, you may try it like this:

```
ALTER TABLE mytable MODIFY price float
```

Solution