Re: How to increase Column width of table

Hello,

Atul here, i have one table and i would like to increase the length of
existing column and the sql statement is

Exisiting Column is "vehicle_make" varchar(30)

SQL: alter table commute_profile alter column "vehicle_make"
varchar(100)

But this gives error.

ERROR: parser: parse error at or near "varchar"

Please anyone give me the solution for the above.

Thank you.

Regards,
Atul