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

sybase alter-table
Ziyang Zhang picture Ziyang Zhang · Jun 28, 2012 · Viewed 43.7k times · Source

I searched for a while and can't get an answer.

Why this doesn't work? ALTER TABLE mytable ALTER COLUMN price DOUBLE

Answer

aF. picture aF. · Jun 29, 2012

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

Related questions

Sybase/ALTER TABLE: how to turn an existing column from non-nullable to nullable?

Hopefully the title has made it quite clear. I would like to see an example of a alter table statement that can change an existing non-nullable column in a Sybase table to nullable.

Read More
Convert INT to VARCHAR SQL

I am using Sybase and I am doing a select which returns me a column called "iftype", but its type is int and I need to convert into varchar. When I try to do the select without the convert function …

Read More
Cannot insert explicit value for identity column in table 'table' when IDENTITY_INSERT is set to OFF

I have the below error when I execute the following script. What is the error about, and how it can be resolved? Insert table(OperationID,OpDescription,FilterID) values (20,'Hierachy Update',1) Error: Server: Msg 544, Level 16, State 1, Line 1 Cannot insert explicit value …

Read More