Difference between revisions of "Person.CountryRegion (table)"

From dbscript Online Help
Jump to: navigation, search
 
(18 intermediate revisions by the same user not shown)
Line 2: Line 2:
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
−
|-
+
|- valign="top"
 
| '''Table
 
| '''Table
 
| Person.CountryRegion
 
| Person.CountryRegion
−
|-
+
|- valign="top"
 +
| '''Description
 +
| Lookup table containing the ISO standard codes for countries and regions.
 
|}
 
|}
  
−
 
+
=== Columns ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
Line 15: Line 17:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
−
| '''PK
+
| '''Description
−
| '''Index
+
 
−
+
|- valign="top"
−
|-
 
 
| CountryRegionCode
 
| CountryRegionCode
 
| nvarchar(3)
 
| nvarchar(3)
 
| not null
 
| not null
 
|  
 
|  
−
| PK_CountryRegion_CountryRegionCode
+
| ISO standard code for countries and regions.
−
|
+
|- valign="top"
−
|-
 
 
| Name
 
| Name
 
| dbo.Name
 
| dbo.Name
 
| not null
 
| not null
 
|  
 
|  
−
|  
+
| Country or region name.
−
| AK_CountryRegion_Name
+
|- valign="top"
−
|-
 
 
| ModifiedDate
 
| ModifiedDate
 
| datetime
 
| datetime
 
| not null
 
| not null
 
| (getdate())
 
| (getdate())
−
|  
+
| Date and time the record was last updated.
−
|  
+
|}
 +
 
 +
=== Primary Key ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Primary Key
 +
| '''Columns
 +
|- valign="top"
 +
| PK_CountryRegion_CountryRegionCode
 +
| CountryRegionCode
 
|}
 
|}
  
 +
=== Indexes ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Index
 +
| '''Type
 +
| '''Columns
  
 +
|- valign="top"
 +
| AK_CountryRegion_Name
 +
| Unique
 +
| Name
 +
|}
  
 +
=== Detail Tables ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
Line 48: Line 68:
 
| '''Column
 
| '''Column
 
| '''Referencing Column
 
| '''Referencing Column
−
+
 
−
|-
+
|- valign="top"
 
| [[Sales.CountryRegionCurrency_(table)|Sales.CountryRegionCurrency]]
 
| [[Sales.CountryRegionCurrency_(table)|Sales.CountryRegionCurrency]]
 
| CountryRegionCode
 
| CountryRegionCode
 
| CountryRegionCode
 
| CountryRegionCode
−
|-
+
|- valign="top"
 
| [[Person.StateProvince_(table)|Person.StateProvince]]
 
| [[Person.StateProvince_(table)|Person.StateProvince]]
 
| CountryRegionCode
 
| CountryRegionCode
 
| CountryRegionCode
 
| CountryRegionCode
 
|}
 
|}
 +
 +
=== References ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Dependency Type
 +
| '''Object Type
 +
| '''Referenced Object
 +
 +
|- valign="top"
 +
| Data Type
 +
| Type
 +
| [[dbo.Name_(type)|dbo.Name]]
 +
 +
|- valign="top"
 +
| Schema
 +
| Schema
 +
| [[Person_(schema)|Person]]
 +
 +
|}
 +
 +
=== Dependencies ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Reference Type
 +
| '''Object Type
 +
| '''Referencing Object
 +
 +
|- valign="top"
 +
| Select
 +
| View
 +
| [[HumanResources.vEmployee_(view)|HumanResources.vEmployee]]
 +
 +
|- valign="top"
 +
| Select
 +
| View
 +
| [[Person.vStateProvinceCountryRegion_(view)|Person.vStateProvinceCountryRegion]]
 +
 +
|- valign="top"
 +
| Select
 +
| View
 +
| [[Purchasing.vVendor_(view)|Purchasing.vVendor]]
 +
 +
|- valign="top"
 +
| Select
 +
| View
 +
| [[Sales.vIndividualCustomer_(view)|Sales.vIndividualCustomer]]
 +
 +
|- valign="top"
 +
| Select
 +
| View
 +
| [[Sales.vSalesPerson_(view)|Sales.vSalesPerson]]
 +
 +
|- valign="top"
 +
| Select
 +
| View
 +
| [[Sales.vStoreWithDemographics_(view)|Sales.vStoreWithDemographics]]
 +
 +
|}
 +
 +
 
== wikivalues ==
 
== wikivalues ==
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
−
|-
+
|- valign="top"
 
| '''Table Values
 
| '''Table Values
 
| Person.CountryRegion
 
| Person.CountryRegion
−
|-
 
 
|}
 
|}
  
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
  
−
{| border="1" cellpadding="5" cellspacing="0"  style="border-collapse:collapse"
 
−
|- style="background:silver"
 
 
| '''CountryRegionCode
 
| '''CountryRegionCode
 
| '''Name
 
| '''Name
−
|-  
+
|- valign="top"
−
| AF
+
 
−
| Afghanistan
+
| AF
−
|-  
+
| Afghanistan
−
| AL
+
|- valign="top"
−
| Albania
+
 
−
|-  
+
| AL
−
| DZ
+
| Albania
−
| Algeria
+
|- valign="top"
−
|-  
+
 
−
| AS
+
| DZ
−
| American Samoa
+
| Algeria
−
|-  
+
|- valign="top"
−
| AD
+
 
−
| Andorra
+
| AS
−
|-  
+
| American Samoa
−
| AO
+
|- valign="top"
−
| Angola
+
 
−
|-  
+
| AD
−
| AI
+
| Andorra
−
| Anguilla
+
|- valign="top"
−
|-  
+
 
−
| AQ
+
| AO
−
| Antarctica
+
| Angola
−
|-  
+
|- valign="top"
−
| AG
+
 
−
| Antigua and Barbuda
+
| AI
−
|-  
+
| Anguilla
−
| AR
+
|- valign="top"
−
| Argentina
+
 
−
|-  
+
| AQ
−
| AM
+
| Antarctica
−
| Armenia
+
|- valign="top"
−
|-  
+
 
−
| AW
+
| AG
−
| Aruba
+
| Antigua and Barbuda
−
|-  
+
|- valign="top"
−
| AU
+
 
−
| Australia
+
| AR
−
|-  
+
| Argentina
−
| AT
+
|- valign="top"
−
| Austria
+
 
−
|-  
+
| AM
−
| AZ
+
| Armenia
−
| Azerbaijan
+
|- valign="top"
−
|-  
+
 
−
| BS
+
| AW
−
| Bahamas, The
+
| Aruba
−
|-  
+
|- valign="top"
−
| BH
+
 
−
| Bahrain
+
| AU
−
|-  
+
| Australia
−
| BD
+
|- valign="top"
−
| Bangladesh
+
 
−
|-  
+
| AT
−
| BB
+
| Austria
−
| Barbados
+
|- valign="top"
−
|-  
+
 
−
| BY
+
| AZ
−
| Belarus
+
| Azerbaijan
−
|-  
+
|- valign="top"
−
| BE
+
 
−
| Belgium
+
| BS
−
|-  
+
| Bahamas, The
−
| BZ
+
|- valign="top"
−
| Belize
+
 
−
|-  
+
| BH
−
| BJ
+
| Bahrain
−
| Benin
+
|- valign="top"
−
|-  
+
 
−
| BM
+
| BD
−
| Bermuda
+
| Bangladesh
−
|-  
+
|- valign="top"
−
| BT
+
 
−
| Bhutan
+
| BB
−
|-  
+
| Barbados
−
| BO
+
|- valign="top"
−
| Bolivia
+
 
−
|-  
+
| BY
−
| BA
+
| Belarus
−
| Bosnia and Herzegovina
+
|- valign="top"
−
|-  
+
 
−
| BW
+
| BE
−
| Botswana
+
| Belgium
−
|-  
+
|- valign="top"
−
| BV
+
 
−
| Bouvet Island
+
| BZ
−
|-  
+
| Belize
−
| BR
+
|- valign="top"
−
| Brazil
+
 
−
|-  
+
| BJ
−
| IO
+
| Benin
−
| British Indian Ocean Territory
+
|- valign="top"
−
|-  
+
 
−
| BN
+
| BM
−
| Brunei
+
| Bermuda
−
|-  
+
|- valign="top"
−
| BG
+
 
−
| Bulgaria
+
| BT
−
|-  
+
| Bhutan
−
| BF
+
|- valign="top"
−
| Burkina Faso
+
 
−
|-  
+
| BO
−
| BI
+
| Bolivia
−
| Burundi
+
|- valign="top"
−
|-  
+
 
−
| KH
+
| BA
−
| Cambodia
+
| Bosnia and Herzegovina
−
|-  
+
|- valign="top"
−
| CM
+
 
−
| Cameroon
+
| BW
−
|-  
+
| Botswana
−
| CA
+
|- valign="top"
−
| Canada
+
 
−
|-  
+
| BV
−
| CV
+
| Bouvet Island
−
| Cape Verde
+
|- valign="top"
−
|-  
+
 
−
| KY
+
| BR
−
| Cayman Islands
+
| Brazil
−
|-  
+
|- valign="top"
−
| CF
+
 
−
| Central African Republic
+
| IO
−
|-  
+
| British Indian Ocean Territory
−
| TD
+
|- valign="top"
−
| Chad
+
 
−
|-  
+
| BN
−
| CL
+
| Brunei
−
| Chile
+
|- valign="top"
−
|-  
+
 
−
| CN
+
| BG
−
| China
+
| Bulgaria
−
|-  
+
|- valign="top"
−
| CX
+
 
−
| Christmas Island
+
| BF
−
|-  
+
| Burkina Faso
−
| CC
+
|- valign="top"
−
| Cocos (Keeling) Islands
+
 
−
|-  
+
| BI
−
| CO
+
| Burundi
−
| Colombia
+
|- valign="top"
−
|-  
+
 
−
| KM
+
| KH
−
| Comoros
+
| Cambodia
−
|-  
+
|- valign="top"
−
| CG
+
 
−
| Congo
+
| CM
−
|-  
+
| Cameroon
−
| CD
+
|- valign="top"
−
| Congo (DRC)
+
 
−
|-  
+
| CA
−
| CK
+
| Canada
−
| Cook Islands
+
|- valign="top"
−
|-  
+
 
−
| CR
+
| CV
−
| Costa Rica
+
| Cape Verde
−
|-  
+
|- valign="top"
−
| CI
+
 
−
| Côte d''Ivoire
+
| KY
−
|-  
+
| Cayman Islands
−
| HR
+
|- valign="top"
−
| Croatia
+
 
−
|-  
+
| CF
−
| CU
+
| Central African Republic
−
| Cuba
+
|- valign="top"
−
|-  
+
 
−
| CY
+
| TD
−
| Cyprus
+
| Chad
−
|-  
+
|- valign="top"
−
| CZ
+
 
−
| Czech Republic
+
| CL
−
|-  
+
| Chile
−
| DK
+
|- valign="top"
−
| Denmark
+
 
−
|-  
+
| CN
−
| DJ
+
| China
−
| Djibouti
+
|- valign="top"
−
|-  
+
 
−
| DM
+
| CX
−
| Dominica
+
| Christmas Island
−
|-  
+
|- valign="top"
−
| DO
+
 
−
| Dominican Republic
+
| CC
−
|-  
+
| Cocos (Keeling) Islands
−
| EC
+
|- valign="top"
−
| Ecuador
+
 
−
|-  
+
| CO
−
| EG
+
| Colombia
−
| Egypt
+
|- valign="top"
−
|-  
+
 
−
| SV
+
| KM
−
| El Salvador
+
| Comoros
−
|-  
+
|- valign="top"
−
| GQ
+
 
−
| Equatorial Guinea
+
| CG
−
|-  
+
| Congo
−
| ER
+
|- valign="top"
−
| Eritrea
+
 
−
|-  
+
| CD
−
| EE
+
| Congo (DRC)
−
| Estonia
+
|- valign="top"
−
|-  
+
 
−
| ET
+
| CK
−
| Ethiopia
+
| Cook Islands
−
|-  
+
|- valign="top"
−
| FK
+
 
−
| Falkland Islands (Islas Malvinas)
+
| CR
−
|-  
+
| Costa Rica
−
| FO
+
|- valign="top"
−
| Faroe Islands
+
 
−
|-  
+
| CI
−
| FJ
+
| Côte d''Ivoire
−
| Fiji Islands
+
|- valign="top"
−
|-  
+
 
−
| FI
+
| HR
−
| Finland
+
| Croatia
−
|-  
+
|- valign="top"
−
| FR
+
 
−
| France
+
| CU
−
|-  
+
| Cuba
−
| GF
+
|- valign="top"
−
| French Guiana
+
 
−
|-  
+
| CY
−
| PF
+
| Cyprus
−
| French Polynesia
+
|- valign="top"
−
|-  
+
 
−
| TF
+
| CZ
−
| French Southern and Antarctic Lands
+
| Czech Republic
−
|-  
+
|- valign="top"
−
| GA
+
 
−
| Gabon
+
| DK
−
|-  
+
| Denmark
−
| GM
+
|- valign="top"
−
| Gambia, The
+
 
−
|-  
+
| DJ
−
| GE
+
| Djibouti
−
| Georgia
+
|- valign="top"
−
|-  
+
 
−
| DE
+
| DM
−
| Germany
+
| Dominica
−
|-  
+
|- valign="top"
−
| GH
+
 
−
| Ghana
+
| DO
−
|-  
+
| Dominican Republic
−
| GI
+
|- valign="top"
−
| Gibraltar
+
 
−
|-  
+
| EC
−
| GR
+
| Ecuador
−
| Greece
+
|- valign="top"
−
|-  
+
 
−
| GL
+
| EG
−
| Greenland
+
| Egypt
−
|-  
+
|- valign="top"
−
| GD
+
 
−
| Grenada
+
| SV
−
|-  
+
| El Salvador
−
| GP
+
|- valign="top"
−
| Guadeloupe
+
 
−
|-  
+
| GQ
−
| GU
+
| Equatorial Guinea
−
| Guam
+
|- valign="top"
−
|-  
+
 
−
| GT
+
| ER
−
| Guatemala
+
| Eritrea
−
|-  
+
|- valign="top"
−
| GN
+
 
−
| Guinea
+
| EE
−
|-  
+
| Estonia
−
| GW
+
|- valign="top"
−
| Guinea-Bissau
+
 
−
|-  
+
| ET
−
| GY
+
| Ethiopia
−
| Guyana
+
|- valign="top"
−
|-  
+
 
−
| HT
+
| FK
−
| Haiti
+
| Falkland Islands (Islas Malvinas)
−
|-  
+
|- valign="top"
−
| HM
+
 
−
| Heard Island and McDonald Islands
+
| FO
−
|-  
+
| Faroe Islands
−
| HN
+
|- valign="top"
−
| Honduras
+
 
−
|-  
+
| FJ
−
| HK
+
| Fiji Islands
−
| Hong Kong SAR
+
|- valign="top"
−
|-  
+
 
−
| HU
+
| FI
−
| Hungary
+
| Finland
−
|-  
+
|- valign="top"
−
| IS
+
 
−
| Iceland
+
| FR
−
|-  
+
| France
−
| IN
+
|- valign="top"
−
| India
+
 
−
|-  
+
| GF
−
| ID
+
| French Guiana
−
| Indonesia
+
|- valign="top"
−
|-  
+
 
−
| IR
+
| PF
−
| Iran
+
| French Polynesia
−
|-  
+
|- valign="top"
−
| IQ
+
 
−
| Iraq
+
| TF
−
|-  
+
| French Southern and Antarctic Lands
−
| IE
+
|- valign="top"
−
| Ireland
+
 
−
|-  
+
| GA
−
| IL
+
| Gabon
−
| Israel
+
|- valign="top"
−
|-  
+
 
−
| IT
+
| GM
−
| Italy
+
| Gambia, The
−
|-  
+
|- valign="top"
−
| JM
+
 
−
| Jamaica
+
| GE
−
|-  
+
| Georgia
−
| JP
+
|- valign="top"
−
| Japan
+
 
−
|-  
+
| DE
−
| JO
+
| Germany
−
| Jordan
+
|- valign="top"
−
|-  
+
 
−
| KZ
+
| GH
−
| Kazakhstan
+
| Ghana
−
|-  
+
|- valign="top"
−
| KE
+
 
−
| Kenya
+
| GI
−
|-  
+
| Gibraltar
−
| KI
+
|- valign="top"
−
| Kiribati
+
 
−
|-  
+
| GR
−
| KR
+
| Greece
−
| Korea
+
|- valign="top"
−
|-  
+
 
−
| KW
+
| GL
−
| Kuwait
+
| Greenland
−
|-  
+
|- valign="top"
−
| KG
+
 
−
| Kyrgyzstan
+
| GD
−
|-  
+
| Grenada
−
| LA
+
|- valign="top"
−
| Laos
+
 
−
|-  
+
| GP
−
| LV
+
| Guadeloupe
−
| Latvia
+
|- valign="top"
−
|-  
+
 
−
| LB
+
| GU
−
| Lebanon
+
| Guam
−
|-  
+
|- valign="top"
−
| LS
+
 
−
| Lesotho
+
| GT
−
|-  
+
| Guatemala
−
| LR
+
|- valign="top"
−
| Liberia
+
 
−
|-  
+
| GN
−
| LY
+
| Guinea
−
| Libya
+
|- valign="top"
−
|-  
+
 
−
| LI
+
| GW
−
| Liechtenstein
+
| Guinea-Bissau
−
|-  
+
|- valign="top"
−
| LT
+
 
−
| Lithuania
+
| GY
−
|-  
+
| Guyana
−
| LU
+
|- valign="top"
−
| Luxembourg
+
 
−
|-  
+
| HT
−
| MO
+
| Haiti
−
| Macao SAR
+
|- valign="top"
−
|-  
+
 
−
| MK
+
| HM
−
| Macedonia, Former Yugoslav Republic of
+
| Heard Island and McDonald Islands
−
|-  
+
|- valign="top"
−
| MG
+
 
−
| Madagascar
+
| HN
−
|-  
+
| Honduras
−
| MW
+
|- valign="top"
−
| Malawi
+
 
−
|-  
+
| HK
−
| MY
+
| Hong Kong SAR
−
| Malaysia
+
|- valign="top"
−
|-  
+
 
−
| MV
+
| HU
−
| Maldives
+
| Hungary
−
|-  
+
|- valign="top"
−
| ML
+
 
−
| Mali
+
| IS
−
|-  
+
| Iceland
−
| MT
+
|- valign="top"
−
| Malta
+
 
−
|-  
+
| IN
−
| MH
+
| India
−
| Marshall Islands
+
|- valign="top"
−
|-  
+
 
−
| MQ
+
| ID
−
| Martinique
+
| Indonesia
−
|-  
+
|- valign="top"
−
| MR
+
 
−
| Mauritania
+
| IR
−
|-  
+
| Iran
−
| MU
+
|- valign="top"
−
| Mauritius
+
 
−
|-  
+
| IQ
−
| YT
+
| Iraq
−
| Mayotte
+
|- valign="top"
−
|-  
+
 
−
| MX
+
| IE
−
| Mexico
+
| Ireland
−
|-  
+
|- valign="top"
−
| FM
+
 
−
| Micronesia
+
| IL
−
|-  
+
| Israel
−
| MD
+
|- valign="top"
−
| Moldova
+
 
−
|-  
+
| IT
−
| MC
+
| Italy
−
| Monaco
+
|- valign="top"
−
|-  
+
 
−
| MN
+
| JM
−
| Mongolia
+
| Jamaica
−
|-  
+
|- valign="top"
−
| MS
+
 
−
| Montserrat
+
| JP
−
|-  
+
| Japan
−
| MA
+
|- valign="top"
−
| Morocco
+
 
−
|-  
+
| JO
−
| MZ
+
| Jordan
−
| Mozambique
+
|- valign="top"
−
|-  
+
 
−
| MM
+
| KZ
−
| Myanmar
+
| Kazakhstan
−
|-  
+
|- valign="top"
−
| NA
+
 
−
| Namibia
+
| KE
−
|-  
+
| Kenya
−
| NR
+
|- valign="top"
−
| Nauru
+
 
−
|-  
+
| KI
−
| NP
+
| Kiribati
−
| Nepal
+
|- valign="top"
−
|-  
+
 
−
| NL
+
| KR
−
| Netherlands
+
| Korea
−
|-  
+
|- valign="top"
−
| AN
+
 
−
| Netherlands Antilles
+
| KW
−
|-  
+
| Kuwait
−
| NC
+
|- valign="top"
−
| New Caledonia
+
 
−
|-  
+
| KG
−
| NZ
+
| Kyrgyzstan
−
| New Zealand
+
|- valign="top"
−
|-  
+
 
−
| NI
+
| LA
−
| Nicaragua
+
| Laos
−
|-  
+
|- valign="top"
−
| NE
+
 
−
| Niger
+
| LV
−
|-  
+
| Latvia
−
| NG
+
|- valign="top"
−
| Nigeria
+
 
−
|-  
+
| LB
−
| NU
+
| Lebanon
−
| Niue
+
|- valign="top"
−
|-  
+
 
−
| NF
+
| LS
−
| Norfolk Island
+
| Lesotho
−
|-  
+
|- valign="top"
−
| KP
+
 
−
| North Korea
+
| LR
−
|-  
+
| Liberia
−
| MP
+
|- valign="top"
−
| Northern Mariana Islands
+
 
−
|-  
+
| LY
−
| NO
+
| Libya
−
| Norway
+
|- valign="top"
−
|-  
+
 
−
| OM
+
| LI
−
| Oman
+
| Liechtenstein
−
|-  
+
|- valign="top"
−
| PK
+
 
−
| Pakistan
+
| LT
−
|-  
+
| Lithuania
−
| PW
+
|- valign="top"
−
| Palau
+
 
−
|-  
+
| LU
−
| PS
+
| Luxembourg
−
| Palestinian Authority
+
|- valign="top"
−
|-  
+
 
−
| PA
+
| MO
−
| Panama
+
| Macao SAR
−
|-  
+
|- valign="top"
−
| PG
+
 
−
| Papua New Guinea
+
| MK
−
|-  
+
| Macedonia, Former Yugoslav Republic of
−
| PY
+
|- valign="top"
−
| Paraguay
+
 
−
|-  
+
| MG
−
| PE
+
| Madagascar
−
| Peru
+
|- valign="top"
−
|-  
+
 
−
| PH
+
| MW
−
| Philippines
+
| Malawi
−
|-  
+
|- valign="top"
−
| PN
+
 
−
| Pitcairn Islands
+
| MY
−
|-  
+
| Malaysia
−
| PL
+
|- valign="top"
−
| Poland
+
 
−
|-  
+
| MV
−
| PT
+
| Maldives
−
| Portugal
+
|- valign="top"
−
|-  
+
 
−
| PR
+
| ML
−
| Puerto Rico
+
| Mali
−
|-  
+
|- valign="top"
−
| QA
+
 
−
| Qatar
+
| MT
−
|-  
+
| Malta
−
| RE
+
|- valign="top"
−
| Réunion
+
 
−
|-  
+
| MH
−
| RO
+
| Marshall Islands
−
| Romania
+
|- valign="top"
−
|-  
+
 
−
| RU
+
| MQ
−
| Russia
+
| Martinique
−
|-  
+
|- valign="top"
−
| RW
+
 
−
| Rwanda
+
| MR
−
|-  
+
| Mauritania
−
| SH
+
|- valign="top"
−
| Saint Helena
+
 
−
|-  
+
| MU
−
| KN
+
| Mauritius
−
| Saint Kitts and Nevis
+
|- valign="top"
−
|-  
+
 
−
| LC
+
| YT
−
| Saint Lucia
+
| Mayotte
−
|-  
+
|- valign="top"
−
| PM
+
 
−
| Saint Pierre and Miquelon
+
| MX
−
|-  
+
| Mexico
−
| VC
+
|- valign="top"
−
| Saint Vincent and the Grenadine
+
 
−
|-  
+
| FM
−
| WS
+
| Micronesia
−
| Samoa
+
|- valign="top"
−
|-  
+
 
−
| SM
+
| MD
−
| San Marino
+
| Moldova
−
|-  
+
|- valign="top"
−
| ST
+
 
−
| São Tomé and Príncipe
+
| MC
−
|-  
+
| Monaco
−
| SA
+
|- valign="top"
−
| Saudi Arabia
+
 
−
|-  
+
| MN
−
| SN
+
| Mongolia
−
| Senegal
+
|- valign="top"
−
|-  
+
 
−
| CS
+
| MS
−
| Serbia and Montenegro
+
| Montserrat
−
|-  
+
|- valign="top"
−
| SC
+
 
−
| Seychelles
+
| MA
−
|-  
+
| Morocco
−
| SL
+
|- valign="top"
−
| Sierra Leone
+
 
−
|-  
+
| MZ
−
| SG
+
| Mozambique
−
| Singapore
+
|- valign="top"
−
|-  
+
 
−
| SK
+
| MM
−
| Slovakia
+
| Myanmar
−
|-  
+
|- valign="top"
−
| SI
+
 
−
| Slovenia
+
| NA
−
|-  
+
| Namibia
−
| SB
+
|- valign="top"
−
| Solomon Islands
+
 
−
|-  
+
| NR
−
| SO
+
| Nauru
−
| Somalia
+
|- valign="top"
−
|-  
+
 
−
| ZA
+
| NP
−
| South Africa
+
| Nepal
−
|-  
+
|- valign="top"
−
| GS
+
 
−
| South Georgia and the South Sandwich Islands
+
| NL
−
|-  
+
| Netherlands
−
| ES
+
|- valign="top"
−
| Spain
+
 
−
|-  
+
| AN
−
| LK
+
| Netherlands Antilles
−
| Sri Lanka
+
|- valign="top"
−
|-  
+
 
−
| SD
+
| NC
−
| Sudan
+
| New Caledonia
−
|-  
+
|- valign="top"
−
| SR
+
 
−
| Suriname
+
| NZ
−
|-  
+
| New Zealand
−
| SJ
+
|- valign="top"
−
| Svalbard and Jan Mayen
+
 
−
|-  
+
| NI
−
| SZ
+
| Nicaragua
−
| Swaziland
+
|- valign="top"
−
|-  
+
 
−
| SE
+
| NE
−
| Sweden
+
| Niger
−
|-  
+
|- valign="top"
−
| CH
+
 
−
| Switzerland
+
| NG
−
|-  
+
| Nigeria
−
| SY
+
|- valign="top"
−
| Syria
+
 
−
|-  
+
| NU
−
| TW
+
| Niue
−
| Taiwan
+
|- valign="top"
−
|-  
+
 
−
| TJ
+
| NF
−
| Tajikistan
+
| Norfolk Island
−
|-  
+
|- valign="top"
−
| TZ
+
 
−
| Tanzania
+
| KP
−
|-  
+
| North Korea
−
| TH
+
|- valign="top"
−
| Thailand
+
 
−
|-  
+
| MP
−
| TL
+
| Northern Mariana Islands
−
| Timor-Leste
+
|- valign="top"
−
|-  
+
 
−
| TG
+
| NO
−
| Togo
+
| Norway
−
|-  
+
|- valign="top"
−
| TK
+
 
−
| Tokelau
+
| OM
−
|-  
+
| Oman
−
| TO
+
|- valign="top"
−
| Tonga
+
 
−
|-  
+
| PK
−
| TT
+
| Pakistan
−
| Trinidad and Tobago
+
|- valign="top"
−
|-  
+
 
−
| TN
+
| PW
−
| Tunisia
+
| Palau
−
|-  
+
|- valign="top"
−
| TR
+
 
−
| Turkey
+
| PS
−
|-  
+
| Palestinian Authority
−
| TM
+
|- valign="top"
−
| Turkmenistan
+
 
−
|-  
+
| PA
−
| TC
+
| Panama
−
| Turks and Caicos Islands
+
|- valign="top"
−
|-  
+
 
−
| TV
+
| PG
−
| Tuvalu
+
| Papua New Guinea
−
|-  
+
|- valign="top"
−
| UM
+
 
−
| U.S. Minor Outlying Islands
+
| PY
−
|-  
+
| Paraguay
−
| UG
+
|- valign="top"
−
| Uganda
+
 
−
|-  
+
| PE
−
| UA
+
| Peru
−
| Ukraine
+
|- valign="top"
−
|-  
+
 
−
| AE
+
| PH
−
| United Arab Emirates
+
| Philippines
−
|-  
+
|- valign="top"
−
| GB
+
 
−
| United Kingdom
+
| PN
−
|-  
+
| Pitcairn Islands
−
| US
+
|- valign="top"
−
| United States
+
 
−
|-  
+
| PL
−
| UY
+
| Poland
−
| Uruguay
+
|- valign="top"
−
|-  
+
 
−
| UZ
+
| PT
−
| Uzbekistan
+
| Portugal
−
|-  
+
|- valign="top"
−
| VU
+
 
−
| Vanuatu
+
| PR
−
|-  
+
| Puerto Rico
−
| VA
+
|- valign="top"
−
| Vatican City
+
 
−
|-  
+
| QA
−
| VE
+
| Qatar
−
| Venezuela
+
|- valign="top"
−
|-  
+
 
−
| VN
+
| RE
−
| Vietnam
+
| Réunion
−
|-  
+
|- valign="top"
−
| VG
+
 
−
| Virgin Islands, British
+
| RO
−
|-  
+
| Romania
−
| VI
+
|- valign="top"
−
| Virgin Islands, U.S.
+
 
−
|-  
+
| RU
−
| WF
+
| Russia
−
| Wallis and Futuna
+
|- valign="top"
−
|-  
+
 
−
| YE
+
| RW
−
| Yemen
+
| Rwanda
−
|-  
+
|- valign="top"
−
| ZM
+
 
−
| Zambia
+
| SH
−
|-  
+
| Saint Helena
−
| ZW
+
|- valign="top"
−
| Zimbabwe
+
 
 +
| KN
 +
| Saint Kitts and Nevis
 +
|- valign="top"
 +
 
 +
| LC
 +
| Saint Lucia
 +
|- valign="top"
 +
 
 +
| PM
 +
| Saint Pierre and Miquelon
 +
|- valign="top"
 +
 
 +
| VC
 +
| Saint Vincent and the Grenadine
 +
|- valign="top"
 +
 
 +
| WS
 +
| Samoa
 +
|- valign="top"
 +
 
 +
| SM
 +
| San Marino
 +
|- valign="top"
 +
 
 +
| ST
 +
| São Tomé and Príncipe
 +
|- valign="top"
 +
 
 +
| SA
 +
| Saudi Arabia
 +
|- valign="top"
 +
 
 +
| SN
 +
| Senegal
 +
|- valign="top"
 +
 
 +
| CS
 +
| Serbia and Montenegro
 +
|- valign="top"
 +
 
 +
| SC
 +
| Seychelles
 +
|- valign="top"
 +
 
 +
| SL
 +
| Sierra Leone
 +
|- valign="top"
 +
 
 +
| SG
 +
| Singapore
 +
|- valign="top"
 +
 
 +
| SK
 +
| Slovakia
 +
|- valign="top"
 +
 
 +
| SI
 +
| Slovenia
 +
|- valign="top"
 +
 
 +
| SB
 +
| Solomon Islands
 +
|- valign="top"
 +
 
 +
| SO
 +
| Somalia
 +
|- valign="top"
 +
 
 +
| ZA
 +
| South Africa
 +
|- valign="top"
 +
 
 +
| GS
 +
| South Georgia and the South Sandwich Islands
 +
|- valign="top"
 +
 
 +
| ES
 +
| Spain
 +
|- valign="top"
 +
 
 +
| LK
 +
| Sri Lanka
 +
|- valign="top"
 +
 
 +
| SD
 +
| Sudan
 +
|- valign="top"
 +
 
 +
| SR
 +
| Suriname
 +
|- valign="top"
 +
 
 +
| SJ
 +
| Svalbard and Jan Mayen
 +
|- valign="top"
 +
 
 +
| SZ
 +
| Swaziland
 +
|- valign="top"
 +
 
 +
| SE
 +
| Sweden
 +
|- valign="top"
 +
 
 +
| CH
 +
| Switzerland
 +
|- valign="top"
 +
 
 +
| SY
 +
| Syria
 +
|- valign="top"
 +
 
 +
| TW
 +
| Taiwan
 +
|- valign="top"
 +
 
 +
| TJ
 +
| Tajikistan
 +
|- valign="top"
 +
 
 +
| TZ
 +
| Tanzania
 +
|- valign="top"
 +
 
 +
| TH
 +
| Thailand
 +
|- valign="top"
 +
 
 +
| TL
 +
| Timor-Leste
 +
|- valign="top"
 +
 
 +
| TG
 +
| Togo
 +
|- valign="top"
 +
 
 +
| TK
 +
| Tokelau
 +
|- valign="top"
 +
 
 +
| TO
 +
| Tonga
 +
|- valign="top"
 +
 
 +
| TT
 +
| Trinidad and Tobago
 +
|- valign="top"
 +
 
 +
| TN
 +
| Tunisia
 +
|- valign="top"
 +
 
 +
| TR
 +
| Turkey
 +
|- valign="top"
 +
 
 +
| TM
 +
| Turkmenistan
 +
|- valign="top"
 +
 
 +
| TC
 +
| Turks and Caicos Islands
 +
|- valign="top"
 +
 
 +
| TV
 +
| Tuvalu
 +
|- valign="top"
 +
 
 +
| UM
 +
| U.S. Minor Outlying Islands
 +
|- valign="top"
 +
 
 +
| UG
 +
| Uganda
 +
|- valign="top"
 +
 
 +
| UA
 +
| Ukraine
 +
|- valign="top"
 +
 
 +
| AE
 +
| United Arab Emirates
 +
|- valign="top"
 +
 
 +
| GB
 +
| United Kingdom
 +
|- valign="top"
 +
 
 +
| US
 +
| United States
 +
|- valign="top"
 +
 
 +
| UY
 +
| Uruguay
 +
|- valign="top"
 +
 
 +
| UZ
 +
| Uzbekistan
 +
|- valign="top"
 +
 
 +
| VU
 +
| Vanuatu
 +
|- valign="top"
 +
 
 +
| VA
 +
| Vatican City
 +
|- valign="top"
 +
 
 +
| VE
 +
| Venezuela
 +
|- valign="top"
 +
 
 +
| VN
 +
| Vietnam
 +
|- valign="top"
 +
 
 +
| VG
 +
| Virgin Islands, British
 +
|- valign="top"
 +
 
 +
| VI
 +
| Virgin Islands, U.S.
 +
|- valign="top"
 +
 
 +
| WF
 +
| Wallis and Futuna
 +
|- valign="top"
 +
 
 +
| YE
 +
| Yemen
 +
|- valign="top"
 +
 
 +
| ZM
 +
| Zambia
 +
|- valign="top"
 +
 
 +
| ZW
 +
| Zimbabwe
 
|}
 
|}
  
Line 794: Line 1,111:
 
| '''Table
 
| '''Table
 
| Person.CountryRegion
 
| Person.CountryRegion
−
|-
+
|- valign="top"
−
 
 
 
| '''Description
 
| '''Description
 
| Lookup table containing the ISO standard codes for countries and regions.
 
| Lookup table containing the ISO standard codes for countries and regions.
 
|-
 
|-
−
 
 
|}
 
|}
  
Line 809: Line 1,124:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
−
| '''Description
+
| '''Description / PK / Index
−
| '''PK / Index
 
 
 
−
|-
+
|- valign="top"
 
| CountryRegionCode
 
| CountryRegionCode
 
| nvarchar(3)
 
| nvarchar(3)
 
| not null
 
| not null
 
|  
 
|  
−
| ISO standard code for countries and regions.
+
| ISO standard code for countries and regions.<br />PK_CountryRegion_CountryRegionCode
−
| PK_CountryRegion_CountryRegionCode
+
|- valign="top"
−
|-
 
 
| Name
 
| Name
 
| Name
 
| Name
 
| not null
 
| not null
 
|  
 
|  
−
| Country or region name.
+
| Country or region name.<br />AK_CountryRegion_Name
−
| AK_CountryRegion_Name
+
|- valign="top"
−
|-
 
 
| ModifiedDate
 
| ModifiedDate
 
| datetime
 
| datetime
 
| not null
 
| not null
 
| (GETDATE())
 
| (GETDATE())
−
| Date and time the record was last updated.
+
| Date and time the record was last updated.<br />
−
|
 
 
|}
 
|}
  
Line 851: Line 1,162:
 
| CountryRegionCode
 
| CountryRegionCode
 
| CountryRegionCode
 
| CountryRegionCode
 +
|}
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Dependency Type
 +
| '''Object Type
 +
| '''Referenced Object
 +
 +
|-
 +
| Data Type
 +
| Type
 +
| [[dbo.Name_(type)|dbo.Name]]
 +
 +
|-
 +
| Schema
 +
| Schema
 +
| [[Person_(schema)|Person]]
 +
 +
|}
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Reference Type
 +
| '''Object Type
 +
| '''Referencing Object
 +
 +
|-
 +
| Select
 +
| View
 +
| [[HumanResources.vEmployee_(view)|HumanResources.vEmployee]]
 +
 +
|-
 +
| Select
 +
| View
 +
| [[Person.vStateProvinceCountryRegion_(view)|Person.vStateProvinceCountryRegion]]
 +
 +
|-
 +
| Select
 +
| View
 +
| [[Purchasing.vVendor_(view)|Purchasing.vVendor]]
 +
 +
|-
 +
| Select
 +
| View
 +
| [[Sales.vIndividualCustomer_(view)|Sales.vIndividualCustomer]]
 +
 +
|-
 +
| Select
 +
| View
 +
| [[Sales.vSalesPerson_(view)|Sales.vSalesPerson]]
 +
 +
|-
 +
| Select
 +
| View
 +
| [[Sales.vStoreWithDemographics_(view)|Sales.vStoreWithDemographics]]
 +
 
|}
 
|}

Latest revision as of 09:55, 27 August 2011

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]

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

References[edit]

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

Dependencies[edit]

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[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.


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
Retrieved from "http://dbshelp.devio.at/index.php?title=Person.CountryRegion_(table)&oldid=2930"