Search code examples
databasesap-iq

how to modify a column's datatype in sybaseIQ

Does anyone know how to modify a column's datatype in sybaseIQ?

ie i have table: "MY_TABLE" with col STATUS varchar(100) i want to change it to varchar(10)

alter table "MY_TABLE" 
    modify "STATUS" varchar(10)

I have tried, the above, but it doesn't seem to be working.......

    Error: SQL Anywhere Error -1013024: ALTER TABLE MODIFY <column> <datatype> is not supported.
-- (db_alter.cxx 438) SQLState:  QCA24 ErrorCode: 21

thoughts?

Solution

  • As the error message states, modifying a columns data type in IQ is not supported. You would need to add a constraint, or add a new column, copy the data, and drop the old column.

    You are able to modify the columns nullability, just not the underlying data type.