Personally I'd suggest that if you are creating two temp tables with different structures they are serving different purposes. So name them differently according to their purposes e.g. CREATE TABLE #FullDesc and CREATE TABLE #ShortDesc in the case of the original question. It's not like you could query the two tables interchangeably. Suitable modifications to the subsequent control structure would depend on what you are doing.