Hi,

> There is any way to do?
>
> I know I can drop and add the new field...
>
> But I have some dependant fields in other tables, and look for some
> easyer than delete all and recreate all...

Download yourself a trial copy of Database Workbench : www.upscene.com

This allows you to alter a computed by field. Check the "DDL" tab to see how
it's done and learn the trick :-)

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com