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

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

A CHECK constraint has a trigger, i.e., compiled code, so you would certainly need to pay attention to it to prepare for a size increase.

./hb