Subject Re: Change Scale of Numeric Type
Author Adam
--- In, "slalom91" <slalom91@...> wrote:
> I would like to change the scale of field from (15,2) to (15,5). Using
> the alter table x alter collumn x is not going to work for me because
> of a huge list of dependencies. Is there a way to modify a system
> table to make this change or am I stuck with removing a chain of
> dependencies.
> Thanks.

FlameRobin (and probably most other tools) have an option to 'Generate
Rebuilt Script' that writes the scripts to drop and recreate the
dependencies. All you need to do is to add the alter table line and
modify the rebuild script with the new scale where applicable.