USE AdventureWorks
GO
IF OBJECTPROPERTY(object_id('NewIndividual'), 'IsUserTable') = 1
   DROP TABLE NewIndividual
SELECT * INTO NewIndividual
   FROM Sales.Individual
GO

IF OBJECTPROPERTY(object_id('NewCustomer'), 'IsUserTable') = 1
   DROP TABLE NewCustomer
SELECT * INTO NewCustomer
   FROM Sales.Customer
GO


IF OBJECTPROPERTY(object_id('NewCustomerAddress'), 'IsUserTable') = 1
   DROP TABLE NewCustomerAddress
SELECT * INTO NewCustomerAddress 
   FROM Sales.CustomerAddress
GO

IF OBJECTPROPERTY(object_id('NewAddress'), 'IsUserTable') = 1
   DROP TABLE NewAddress
SELECT * INTO NewAddress
     FROM Person.Address
GO

IF OBJECTPROPERTY(object_id('NewVendor'), 'IsUserTable') = 1
   DROP TABLE NewVendor
SELECT * INTO NewVendor
     FROM Purchasing.Vendor
GO

IF OBJECTPROPERTY(object_id('NewVendorContact'), 'IsUserTable') = 1
   DROP TABLE NewVendorContact
SELECT * INTO NewVendorContact
     FROM Purchasing.VendorContact
GO


IF OBJECTPROPERTY(object_id('NewIndividual'), 'IsUserTable') = 1
   DROP TABLE NewIndividual
SELECT * INTO NewIndividual
   FROM Sales.Individual
GO

IF OBJECTPROPERTY(object_id('NewEmployee'), 'IsUserTable') = 1
   DROP TABLE NewEmployee
SELECT * INTO NewEmployee
   FROM HumanResources.Employee
GO

IF OBJECTPROPERTY(object_id('NewSalesOrderHeader'), 'IsUserTable') = 1
   DROP TABLE NewSalesOrderHeader
SELECT * INTO NewSalesOrderHeader
   FROM Sales.SalesOrderHeader
GO

IF OBJECTPROPERTY(object_id('NewSalesOrderDetail'), 'IsUserTable') = 1
   DROP TABLE NewSalesOrderDetail
SELECT * INTO NewSalesOrderDetail
   FROM Sales.SalesOrderDetail
GO


IF OBJECTPROPERTY(object_id('NewProduct'), 'IsUserTable') = 1
   DROP TABLE NewProduct
SELECT * INTO NewProduct
   FROM Production.Product