Quote Originally Posted by ixion
CTAS
Then, Instead of insert, drop the original and rename the newly created table with less data! He'll also need to recreate triggers, indexes and FK's etc...
Dropping the original table is not a wise decision, if the data is huge after purging with too many columns and constraints.