USE [Northwind]
GO
/****** Object:  Table[dbo].[Region]    Script Date: 06/01/201617:50:46 ******/
SET ANSI_NULLSON
GO
SET QUOTED_IDENTIFIERON
GO
CREATE TABLE[dbo].[Region](
      [RegionID] [int] NOTNULL,
      [RegionDescription] [nchar](50) NOT NULL,
 CONSTRAINT[PK_Region] PRIMARY KEYNONCLUSTERED 
(
      [RegionID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON[PRIMARY]
GO
INSERT [dbo].[Region] ([RegionID], [RegionDescription])VALUES (1, N'Eastern')
INSERT [dbo].[Region] ([RegionID], [RegionDescription])VALUES (2, N'Western')
INSERT [dbo].[Region] ([RegionID], [RegionDescription])VALUES (3, N'Northern')
INSERT [dbo].[Region] ([RegionID], [RegionDescription])VALUES (4, N'Southern')