Re: how can i change my table/column constraint

Hi Anand,

> basically copy the table to some other table..
> Drop the old table..
> recreate it with the constraints changed
> Repopulate the table..
would you show me with my two tables?
is it like this?
> >if i create another table named lab2 with same fields and then i move
> >all tuples from lab to lab2, then drop table lab and rename lab2 to
> >lab, is the references constraint in table tb2 still valid?
> >would you show me how to do this?
i create lab2 with the same constraint before i delete lab?
isn't it?
after lab2 created i copy all tuples from lab to lab2...
is it right?
what do you repopulate?
sorry...i'm still not getting on to it
TIA
Didi