How to change the type of a column from varchar(30) to varcahar(100)? alter table easy_table modify column city varchar(100) not null;