how to change the field size of an existing column code example
Example: how to change the field size of an existing column
alter table yourTableName change yourColumnName yourColumnName dataType;
alter table yourTableName change yourColumnName yourColumnName dataType;