Person.CountryRegion (table)

wikibot

Table	Person.CountryRegion
Description	Lookup table containing the ISO standard codes for countries and regions.

Columns

Column	Data Type	Nullable	Default	Description
CountryRegionCode	nvarchar(3)	not null		ISO standard code for countries and regions.
Name	dbo.Name	not null		Country or region name.
ModifiedDate	datetime	not null	(getdate())	Date and time the record was last updated.

Primary Key

Primary Key	Columns
PK_CountryRegion_CountryRegionCode	CountryRegionCode

Indexes

Index	Type	Columns
AK_CountryRegion_Name	Unique	Name

Detail Tables

Detail Table	Column	Referencing Column
Sales.CountryRegionCurrency	CountryRegionCode	CountryRegionCode
Person.StateProvince	CountryRegionCode	CountryRegionCode

References

Dependency Type	Object Type	Referenced Object
Data Type	Type	dbo.Name
Schema	Schema	Person

Dependencies

Reference Type	Object Type	Referencing Object
Select	View	HumanResources.vEmployee
Select	View	Person.vStateProvinceCountryRegion
Select	View	Purchasing.vVendor
Select	View	Sales.vIndividualCustomer
Select	View	Sales.vSalesPerson
Select	View	Sales.vStoreWithDemographics

wikivalues

Table Values

Person.CountryRegion

CountryRegionCode	Name
AF	Afghanistan
AL	Albania
DZ	Algeria
AS	American Samoa
AD	Andorra
AO	Angola
AI	Anguilla
AQ	Antarctica
AG	Antigua and Barbuda
AR	Argentina
AM	Armenia
AW	Aruba
AU	Australia
AT	Austria
AZ	Azerbaijan
BS	Bahamas, The
BH	Bahrain
BD	Bangladesh
BB	Barbados
BY	Belarus
BE	Belgium
BZ	Belize
BJ	Benin
BM	Bermuda
BT	Bhutan
BO	Bolivia
BA	Bosnia and Herzegovina
BW	Botswana
BV	Bouvet Island
BR	Brazil
IO	British Indian Ocean Territory
BN	Brunei
BG	Bulgaria
BF	Burkina Faso
BI	Burundi
KH	Cambodia
CM	Cameroon
CA	Canada
CV	Cape Verde
KY	Cayman Islands
CF	Central African Republic
TD	Chad
CL	Chile
CN	China
CX	Christmas Island
CC	Cocos (Keeling) Islands
CO	Colombia
KM	Comoros
CG	Congo
CD	Congo (DRC)
CK	Cook Islands
CR	Costa Rica
CI	Côte dIvoire
HR	Croatia
CU	Cuba
CY	Cyprus
CZ	Czech Republic
DK	Denmark
DJ	Djibouti
DM	Dominica
DO	Dominican Republic
EC	Ecuador
EG	Egypt
SV	El Salvador
GQ	Equatorial Guinea
ER	Eritrea
EE	Estonia
ET	Ethiopia
FK	Falkland Islands (Islas Malvinas)
FO	Faroe Islands
FJ	Fiji Islands
FI	Finland
FR	France
GF	French Guiana
PF	French Polynesia
TF	French Southern and Antarctic Lands
GA	Gabon
GM	Gambia, The
GE	Georgia
DE	Germany
GH	Ghana
GI	Gibraltar
GR	Greece
GL	Greenland
GD	Grenada
GP	Guadeloupe
GU	Guam
GT	Guatemala
GN	Guinea
GW	Guinea-Bissau
GY	Guyana
HT	Haiti
HM	Heard Island and McDonald Islands
HN	Honduras
HK	Hong Kong SAR
HU	Hungary
IS	Iceland
IN	India
ID	Indonesia
IR	Iran
IQ	Iraq
IE	Ireland
IL	Israel
IT	Italy
JM	Jamaica
JP	Japan
JO	Jordan
KZ	Kazakhstan
KE	Kenya
KI	Kiribati
KR	Korea
KW	Kuwait
KG	Kyrgyzstan
LA	Laos
LV	Latvia
LB	Lebanon
LS	Lesotho
LR	Liberia
LY	Libya
LI	Liechtenstein
LT	Lithuania
LU	Luxembourg
MO	Macao SAR
MK	Macedonia, Former Yugoslav Republic of
MG	Madagascar
MW	Malawi
MY	Malaysia
MV	Maldives
ML	Mali
MT	Malta
MH	Marshall Islands
MQ	Martinique
MR	Mauritania
MU	Mauritius
YT	Mayotte
MX	Mexico
FM	Micronesia
MD	Moldova
MC	Monaco
MN	Mongolia
MS	Montserrat
MA	Morocco
MZ	Mozambique
MM	Myanmar
NA	Namibia
NR	Nauru
NP	Nepal
NL	Netherlands
AN	Netherlands Antilles
NC	New Caledonia
NZ	New Zealand
NI	Nicaragua
NE	Niger
NG	Nigeria
NU	Niue
NF	Norfolk Island
KP	North Korea
MP	Northern Mariana Islands
NO	Norway
OM	Oman
PK	Pakistan
PW	Palau
PS	Palestinian Authority
PA	Panama
PG	Papua New Guinea
PY	Paraguay
PE	Peru
PH	Philippines
PN	Pitcairn Islands
PL	Poland
PT	Portugal
PR	Puerto Rico
QA	Qatar
RE	Réunion
RO	Romania
RU	Russia
RW	Rwanda
SH	Saint Helena
KN	Saint Kitts and Nevis
LC	Saint Lucia
PM	Saint Pierre and Miquelon
VC	Saint Vincent and the Grenadine
WS	Samoa
SM	San Marino
ST	São Tomé and Príncipe
SA	Saudi Arabia
SN	Senegal
CS	Serbia and Montenegro
SC	Seychelles
SL	Sierra Leone
SG	Singapore
SK	Slovakia
SI	Slovenia
SB	Solomon Islands
SO	Somalia
ZA	South Africa
GS	South Georgia and the South Sandwich Islands
ES	Spain
LK	Sri Lanka
SD	Sudan
SR	Suriname
SJ	Svalbard and Jan Mayen
SZ	Swaziland
SE	Sweden
CH	Switzerland
SY	Syria
TW	Taiwan
TJ	Tajikistan
TZ	Tanzania
TH	Thailand
TL	Timor-Leste
TG	Togo
TK	Tokelau
TO	Tonga
TT	Trinidad and Tobago
TN	Tunisia
TR	Turkey
TM	Turkmenistan
TC	Turks and Caicos Islands
TV	Tuvalu
UM	U.S. Minor Outlying Islands
UG	Uganda
UA	Ukraine
AE	United Arab Emirates
GB	United Kingdom
US	United States
UY	Uruguay
UZ	Uzbekistan
VU	Vanuatu
VA	Vatican City
VE	Venezuela
VN	Vietnam
VG	Virgin Islands, British
VI	Virgin Islands, U.S.
WF	Wallis and Futuna
YE	Yemen
ZM	Zambia
ZW	Zimbabwe

automatically generated

Table	Person.CountryRegion
Description	Lookup table containing the ISO standard codes for countries and regions.

Column	Data Type	Nullable	Default	Description / PK / Index
CountryRegionCode	nvarchar(3)	not null		ISO standard code for countries and regions. PK_CountryRegion_CountryRegionCode
Name	Name	not null		Country or region name. AK_CountryRegion_Name
ModifiedDate	datetime	not null	(GETDATE())	Date and time the record was last updated.

Detail Table	Column	Referencing Column
Sales.CountryRegionCurrency	CountryRegionCode	CountryRegionCode
Person.StateProvince	CountryRegionCode	CountryRegionCode

Dependency Type	Object Type	Referenced Object
Data Type	Type	dbo.Name
Schema	Schema	Person

Reference Type	Object Type	Referencing Object
Select	View	HumanResources.vEmployee
Select	View	Person.vStateProvinceCountryRegion
Select	View	Purchasing.vVendor
Select	View	Sales.vIndividualCustomer
Select	View	Sales.vSalesPerson
Select	View	Sales.vStoreWithDemographics