Execute the following Microsoft SQL Server Transact-SQL (T-SQL) script in Management Studio (SSMS) Query Editor, SQLCMD or other client software to create the SupplierType and Supplier tables and populate them:

USE AdventureWorks;

CREATE TABLE "dbo"."SupplierType"
(
"SupplierTypeID" int identity(1,1) PRIMARY KEY,
"Type" varchar(30) NOT NULL,
"Inactive" char(1) NULL default ('A')

);
GO
INSERT dbo.SupplierType (Type) SELECT 'Office Supply'
INSERT dbo.SupplierType (Type) SELECT 'Manufacturing'
INSERT dbo.SupplierType (Type) SELECT 'Buildings'
GO
SELECT * FROM dbo.SupplierType
GO

CREATE TABLE "Supplier"
(
"SupplierID" varchar(8) NOT NULL PRIMARY KEY,
"SupplierTypeID" int NOT NULL,
"SupplierName" varchar(30) NOT NULL,
"ContactPerson" varchar(30) NULL,
"Street" varchar(100) NULL,
"City" varchar(25) NULL,
"State" varchar(25) NULL,
"Country" varchar(25) NULL,
"Zip" varchar(10) NULL,
"Phone" varchar(15) NULL,
"Fax" varchar(15) NULL,
"Email" varchar(100) NULL,
"MobileNo" varchar(15) NULL,
"Inactive" char(1) NULL default ('A'),
"CreateDate" smalldatetime default (getdate()),
"CreatedBy" char(10) NULL

);

INSERT Supplier ("SupplierID",
"SupplierTypeID",
"SupplierName",
"ContactPerson",
"Street",
"City",
"State",
"Country",
"Zip",
"Phone",
"Fax",
"Email",
"MobileNo",
"CreatedBy" )

SELECT 'ALPHAOFF',
1,
'Alpha Office Products',
'Jennifer White',
'244 Broadway, Suite 200',
'New York City',
'NY',
'USA',
'10001',
'212 849-2455',
'212 849-2454',
'jwhite@alphaoffice.com',
'944 848-8599',
'gm'
GO
SELECT * FROM dbo.Supplier
GO