>Mike
>
>Good idea
>
>How would drop a column, an index, or a constraint that was no longer needed?

I'm not using executable code here, just pseudo for discussion purposes, but ...

if columnname exists
drop column columnname

and for indexes and constraints, switch from NOT exists.