Hi

Thanx for that Helen. I kinda did what you said... Im using sqlmanager
from ems and although I dont want to discuss the merits of the products
is this the kinda error I would generally.


Unsuccessful metadata update.
Column ITEMNO from table ITEMS is referenced in CHECK_3.

Regards

M

>>> Helen Borrie <helebor@...> 10/02/08 10:50 AM >>>

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