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

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

This won't work for a primary key though, will it? (I've got a PK size
increase I've been putting off for way too long)
What the lest painful way of doing the same for a primary key? (I was
expecting to have to do all sorts of coping back and forth, adding tempt
fields, dropping them again, etc)

Maya