Thanks for the reply Logician
Im not concerned about clashes, as I already know it upgrades just fine.
What Im trying to do is remove all the 'dead weight' that will no longer be required.
Ive upgraded this db from vb 2.0, so its being added to quite extensively.
Unfortunately for me, all my doco I had on what hacks did what, was lost in a damn nasty HD failure I had a coupel of months ago.
Ive manged to strip out 40 odd additional tables, buts its all the alters to the stock vb tables I really want to get rid of.
And then there is all the templates Id like to take out of the system.
It would be fantastic if I could just run a script that does all this for me right before I upgrade to vb 3.0.
So any suggestions on how to achieve this would be great !