Listing 3: Creation Script for the OrdersArchive Table
IF OBJECT_ID('dbo.OrdersArchive') IS NOT NULL
  DROP TABLE dbo.OrdersArchive;
GO
CREATE TABLE dbo.OrdersArchive
(
  orderid int NOT NULL PRIMARY KEY,
  custid varchar(5) NOT NULL,
  orderdate datetime NOT NULL
);