At 18:41 2/10/2008, you wrote:

>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.

alter table atable
alter myvchar type varchar(15)

As for dependencies, if the column is a foreign key to a varchar of less than 15 then you will have to alter the parent key first.

Also pay attention to any triggers or stored procedures that have defined a varchar(10) variable to take output from the column...

./heLen