Thanks Paul,

It was a lead to start with...

Cheers,

harman

Thanks for the reply... I am only dropping the constraint on some tables...for eg if I want to move the PK to some other column, I would have to drop...