Databases > Northwind > Tables > Territories

Northwind

Territories

Created: Modified:

Columns

  • TerritoryID
    [nvarchar](20) NOT NULL
  • TerritoryDescription
    [nchar](50) NOT NULL
  • RegionID
    [int] NOT NULL

Indexes

  • PK_Territories
    UNIQUE NONCLUSTERED
    TerritoryID

Foreign Keys

  • FK_Territories_Region
    Region
    RegionID ⥱ RegionID

Sample Data

TerritoryID
TerritoryDescription
RegionID
01581
Westboro
1
01730
Bedford
1
01833
Georgetow
1
02116
Boston
1
02139
Cambridge
1
02184
Braintree
1
02903
Providence
1
03049
Hollis
3
03801
Portsmouth
3
06897
Wilton
1
07960
Morristown
1
08837
Edison
1
10019
New York
1
10038
New York
1
11747
Mellvile
1
14450
Fairport
1
19428
Philadelphia
3
19713
Neward
1
20852
Rockville
1
27403
Greensboro
1
27511
Cary
1
29202
Columbia
4
30346
Atlanta
4
31406
Savannah
4
32859
Orlando
4