From dbscript Online Help
wikibot
Table
|
Person.CountryRegion
|
Column
|
Data Type
|
Nullable
|
Default
|
PK
|
Index
|
CountryRegionCode
|
nvarchar(3)
|
not null
|
|
PK_CountryRegion_CountryRegionCode
|
|
Name
|
dbo.Name
|
not null
|
|
|
AK_CountryRegion_Name
|
ModifiedDate
|
datetime
|
not null
|
(getdate())
|
|
|
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.
|
Referenced Object
|
Object Type
|
Dependency Type
|
dbo.Name
|
Type
|
Data Type
|