ALTER TABLE fruits ALTER COLUMN osdb_number TYPE VARCHAR(100);