From dbscript Online Help
wikibot[edit]
| Table
|
Person.CountryRegion
|
| Description
|
Lookup table containing the ISO standard codes for countries and regions.
|
Columns[edit]
| 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[edit]
| Primary Key
|
Columns
|
| PK_CountryRegion_CountryRegionCode
|
CountryRegionCode
|
Indexes[edit]
| Index
|
Type
|
Columns
|
| AK_CountryRegion_Name
|
Unique
|
Name
|
Detail Tables[edit]
References[edit]
| Dependency Type
|
Object Type
|
Referenced Object
|
| Data Type
|
Type
|
dbo.Name
|
| Schema
|
Schema
|
Person
|
Dependencies[edit]
wikivalues[edit]
| 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[edit]
| 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.
|
| Dependency Type
|
Object Type
|
Referenced Object
|
| Data Type
|
Type
|
dbo.Name
|
| Schema
|
Schema
|
Person
|
