Listing 1: Copying Three Tables in the AdventureWorks Database

USE AdventureWorks;
GO

IF EXISTS (SELECT 1 FROM sys.tables
       WHERE name = 'OrderHeader')
   DROP TABLE OrderHeader;
GO
SELECT * INTO dbo.OrderHeader
FROM Sales.SalesOrderHeader;
GO
IF EXISTS (SELECT 1 FROM sys.tables
       WHERE name = 'Territory')
   DROP TABLE Territory;
GO
SELECT * INTO dbo.Territory
FROM Sales.SalesTerritory;
GO
IF EXISTS (SELECT 1 FROM sys.tables
      WHERE name = 'Customers')
   DROP TABLE Customers;
GO
SELECT * INTO dbo.Customers
FROM Sales.Customer;
GO