Re: How to increase Column width of table

Hello,
Atul here, i have one table and i would like to increase the length ofexisting 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