Hi

Are there any painless method of increasing a fields size lets say for
a fields varchar(10) to varchar(15) without having to do quite a bit of
work.
I have worked with oracle extensively and this proved to quite easy and
simple to do with a alter table command. I have a fields that quite
extensively used in my database and trying to extend the fields by 5
characters gives all sort of dependency issues. Do I have to break./drop
all the dependancies to the alter and recreate the dependancies again.
Surely there must be an easier way to do this? BTW the table(s) does
have data in.

Regards

Moegamat