AdventureWorks2019
Person.vStateProvinceCountryRegion
//
Joins StateProvince table with CountryRegion table.
Created: Modified:
Columns
-
StateProvinceID[int] NOT NULL
-
StateProvinceCode[nchar](3) NOT NULL
-
IsOnlyStateProvinceFlag[Flag] NOT NULL
-
StateProvinceName[Name] NOT NULL
-
TerritoryID[int] NOT NULL
-
CountryRegionCode[nvarchar](3) NOT NULL
-
CountryRegionName[Name] NOT NULL
Definition
Sample Data
StateProvinceID
StateProvinceCode
IsOnlyStateProvinceFlag
StateProvinceName
TerritoryID
CountryRegionCode
CountryRegionName
1
AB
NULL
Alberta
6
CA
Canada
2
AK
NULL
Alaska
1
US
United States
3
AL
NULL
Alabama
5
US
United States
4
AR
NULL
Arkansas
3
US
United States
5
AS
true
American Samoa
1
AS
American Samoa
6
AZ
NULL
Arizona
4
US
United States
7
BC
NULL
British Columbia
6
CA
Canada
8
BY
NULL
Bayern
8
DE
Germany
9
CA
NULL
California
4
US
United States
10
CO
NULL
Colorado
3
US
United States
11
CT
NULL
Connecticut
2
US
United States
12
DC
NULL
District of Columbia
2
US
United States
13
DE
NULL
Delaware
2
US
United States
14
ENG
true
England
10
GB
United Kingdom
15
FL
NULL
Florida
5
US
United States
16
FM
true
Micronesia
9
FM
Micronesia
17
GA
NULL
Georgia
5
US
United States
18
GU
NULL
Guam
4
US
United States
19
HE
NULL
Hessen
8
DE
Germany
20
HH
NULL
Hamburg
8
DE
Germany
21
HI
NULL
Hawaii
1
US
United States
22
IA
NULL
Iowa
3
US
United States
23
ID
NULL
Idaho
1
US
United States
24
IL
NULL
Illinois
3
US
United States
25
IN
NULL
Indiana
2
US
United States