Listing 4: Creation Script for the Customers Table
IF OBJECT_ID('dbo.Customers') IS NOT NULL
  DROP TABLE dbo.Customers;
GO
CREATE TABLE dbo.Customers
(
  custid varchar(5) NOT NULL PRIMARY KEY,
  custname varchar(20) NOT NULL,
  country varchar(25) NOT NULL
);

INSERT INTO dbo.Customers(custid, custname, country) VALUES('A', 'Cust A', 'USA');
INSERT INTO dbo.Customers(custid, custname, country) VALUES('B', 'Cust B', 'Australia');