I have 2 to 3 columns in one table that really should be in another table. Is there a way to move columns and data over to another table. I was thinking something like creating the a new table with all the columns I want and then doing an insert based on a select. This will be eventually changed on a production database so I need to keep the names of the tables the same. Thanks for any suggestions.