Alter Table Column

Posted by brucejin on 29-Mar-2011 15:45

I have a column MYCOL of char(2) and I want to change it to char(10). This SQL does not work:

alter table MYSCHEMA.MYTABLE alter COLUMN MYCOL char(10);

What is the correct syntex?

Add column works fine:

alter table MYSCHEMA.MYTABLE add COLUMN MYCOL char(2);

Thanks!

I have manual "OpenEdge® Data Management:SQL Reference" but could not figure out the syntex.

All Replies

Posted by brucejin on 30-Mar-2011 12:59

This will do it:

alter table MYSCHEMA.MYTABLE ALTER COLUMN MYCOL SET PRO_SQL_WIDTH 10

This thread is closed