How to increase attribute lenght

[SkyHigh]

Hi Folks

Is there a way to increase the length of an attribute in a table, I dont see any option in alter table, but I believe it can be done using system tables, its a varchar datatype field and I am running version 7.2.3 on Solaris.

Thanks for you help
Rgds
Brenda

 

[stoolpigeon]

You could always create a new table w/desired set up - copy old table into new - drop old table - rename new to name of old.

If you have a script that was used to build the original table this would be quick and easy.