Fabiano Bonin wrote:

> Because the columns have other dependencies than the referential
> integrity (stored procedure, triggers, etc...), so i'm not able to
> use this statement.
>
> Of course it is, but i'm trying to achieve something FB is not able
> to give me now, that's the reason i'm doing these tests.

Well, if you use FlameRobin, open the table's property page and click
on "Generate rebuild script". It will create DROP/ALTER statements for
all dependend objects. And it will also create CREATE/ALTER statements
that create everything back. In short, the views and constraints are
dropped, triggers and procedures are altered to empty bodies. Views
are even dropped recursively, in case you have view depending on other
views. The CREATE part creates views and constraints, alters triggers
and procedures to full body and also recreates grants for views.

So, just run the DROP part, change the column, run the CREATE part,
and you're done.

</M>