Person CountryRegion (table)

wikibot

TablePerson.CountryRegion
DescriptionLookup table containing the ISO standard codes for countries and regions.

Columns

ColumnData TypeNullableDefaultDescription
CountryRegionCodenvarchar(3)not null ISO standard code for countries and regions.
Namedbo.Namenot null Country or region name.
ModifiedDatedatetimenot null(getdate())Date and time the record was last updated.

Primary Key

Primary KeyColumns
PK_CountryRegion_CountryRegionCodeCountryRegionCode

Indexes

IndexTypeColumns
AK_CountryRegion_NameUniqueName

Detail Tables

Detail TableColumnReferencing Column
Sales.CountryRegionCurrencyCountryRegionCodeCountryRegionCode
Person.StateProvinceCountryRegionCodeCountryRegionCode

References

Dependency TypeObject TypeReferenced Object
Data TypeTypedbo.Name
SchemaSchemaPerson

Dependencies

Reference TypeObject TypeReferencing Object
SelectViewHumanResources.vEmployee
SelectViewPerson.vStateProvinceCountryRegion
SelectViewPurchasing.vVendor
SelectViewSales.vIndividualCustomer
SelectViewSales.vSalesPerson
SelectViewSales.vStoreWithDemographics

wikivalues

Table ValuesPerson.CountryRegion

CountryRegionCodeName
AFAfghanistan
ALAlbania
DZAlgeria
ASAmerican Samoa
ADAndorra
AOAngola
AIAnguilla
AQAntarctica
AGAntigua and Barbuda
ARArgentina
AMArmenia
AWAruba
AUAustralia
ATAustria
AZAzerbaijan
BSBahamas, The
BHBahrain
BDBangladesh
BBBarbados
BYBelarus
BEBelgium
BZBelize
BJBenin
BMBermuda
BTBhutan
BOBolivia
BABosnia and Herzegovina
BWBotswana
BVBouvet Island
BRBrazil
IOBritish Indian Ocean Territory
BNBrunei
BGBulgaria
BFBurkina Faso
BIBurundi
KHCambodia
CMCameroon
CACanada
CVCape Verde
KYCayman Islands
CFCentral African Republic
TDChad
CLChile
CNChina
CXChristmas Island
CCCocos (Keeling) Islands
COColombia
KMComoros
CGCongo
CDCongo (DRC)
CKCook Islands
CRCosta Rica
CICôte d''Ivoire
HRCroatia
CUCuba
CYCyprus
CZCzech Republic
DKDenmark
DJDjibouti
DMDominica
DODominican Republic
ECEcuador
EGEgypt
SVEl Salvador
GQEquatorial Guinea
EREritrea
EEEstonia
ETEthiopia
FKFalkland Islands (Islas Malvinas)
FOFaroe Islands
FJFiji Islands
FIFinland
FRFrance
GFFrench Guiana
PFFrench Polynesia
TFFrench Southern and Antarctic Lands
GAGabon
GMGambia, The
GEGeorgia
DEGermany
GHGhana
GIGibraltar
GRGreece
GLGreenland
GDGrenada
GPGuadeloupe
GUGuam
GTGuatemala
GNGuinea
GWGuinea-Bissau
GYGuyana
HTHaiti
HMHeard Island and McDonald Islands
HNHonduras
HKHong Kong SAR
HUHungary
ISIceland
INIndia
IDIndonesia
IRIran
IQIraq
IEIreland
ILIsrael
ITItaly
JMJamaica
JPJapan
JOJordan
KZKazakhstan
KEKenya
KIKiribati
KRKorea
KWKuwait
KGKyrgyzstan
LALaos
LVLatvia
LBLebanon
LSLesotho
LRLiberia
LYLibya
LILiechtenstein
LTLithuania
LULuxembourg
MOMacao SAR
MKMacedonia, Former Yugoslav Republic of
MGMadagascar
MWMalawi
MYMalaysia
MVMaldives
MLMali
MTMalta
MHMarshall Islands
MQMartinique
MRMauritania
MUMauritius
YTMayotte
MXMexico
FMMicronesia
MDMoldova
MCMonaco
MNMongolia
MSMontserrat
MAMorocco
MZMozambique
MMMyanmar
NANamibia
NRNauru
NPNepal
NLNetherlands
ANNetherlands Antilles
NCNew Caledonia
NZNew Zealand
NINicaragua
NENiger
NGNigeria
NUNiue
NFNorfolk Island
KPNorth Korea
MPNorthern Mariana Islands
NONorway
OMOman
PKPakistan
PWPalau
PSPalestinian Authority
PAPanama
PGPapua New Guinea
PYParaguay
PEPeru
PHPhilippines
PNPitcairn Islands
PLPoland
PTPortugal
PRPuerto Rico
QAQatar
RERéunion
RORomania
RURussia
RWRwanda
SHSaint Helena
KNSaint Kitts and Nevis
LCSaint Lucia
PMSaint Pierre and Miquelon
VCSaint Vincent and the Grenadine
WSSamoa
SMSan Marino
STSão Tomé and Príncipe
SASaudi Arabia
SNSenegal
CSSerbia and Montenegro
SCSeychelles
SLSierra Leone
SGSingapore
SKSlovakia
SISlovenia
SBSolomon Islands
SOSomalia
ZASouth Africa
GSSouth Georgia and the South Sandwich Islands
ESSpain
LKSri Lanka
SDSudan
SRSuriname
SJSvalbard and Jan Mayen
SZSwaziland
SESweden
CHSwitzerland
SYSyria
TWTaiwan
TJTajikistan
TZTanzania
THThailand
TLTimor-Leste
TGTogo
TKTokelau
TOTonga
TTTrinidad and Tobago
TNTunisia
TRTurkey
TMTurkmenistan
TCTurks and Caicos Islands
TVTuvalu
UMU.S. Minor Outlying Islands
UGUganda
UAUkraine
AEUnited Arab Emirates
GBUnited Kingdom
USUnited States
UYUruguay
UZUzbekistan
VUVanuatu
VAVatican City
VEVenezuela
VNVietnam
VGVirgin Islands, British
VIVirgin Islands, U.S.
WFWallis and Futuna
YEYemen
ZMZambia
ZWZimbabwe