1. select * into Customer_tmp from Customer [any where conditions if needed] Select entries from Customer table and create a new table Customer_tmp with the same structure of Customer and Insert them into the new table. Useful to copy a table to a tmpTable.