LISTING 1: Code That Creates Copies of the Orders
 and Order Details Tables

/* If the tables already exist, drop them first:
DROP TABLE o2
DROP TABLE od2 */

SELECT  *
INTO o2
FROM orders
SELECT *
INTO od2
FROM [order details]
GO