Editing Person.CountryRegion (table)

== wikibot ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- valign="top"
| '''Table
| 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"
|- style="background:silver"
| '''Column
| '''Data Type
| '''Nullable
| '''Default
| '''Description

|- valign="top"
| CountryRegionCode
| nvarchar(3)
| not null
| 
| ISO standard code for countries and regions.
|- valign="top"
| Name
| dbo.Name
| not null
| 
| Country or region name.
|- valign="top"
| ModifiedDate
| datetime
| not null
| (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"
|- style="background:silver"
| '''Detail Table
| '''Column
| '''Referencing Column

|- valign="top"
| [[Sales.CountryRegionCurrency_(table)|Sales.CountryRegionCurrency]]
| CountryRegionCode
| CountryRegionCode
|- valign="top"
| [[Person.StateProvince_(table)|Person.StateProvince]]
| 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 ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
| '''Table Values
| Person.CountryRegion
|-
|}


{| border="1" cellpadding="5" cellspacing="0"  style="border-collapse:collapse"
|- style="background:silver" 
| '''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 d''Ivoire
|- 
|	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 ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
| '''Table
| Person.CountryRegion
|- valign="top"
| '''Description
| Lookup table containing the ISO standard codes for countries and regions.
|-
|}


{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Column
| '''Data Type
| '''Nullable
| '''Default
| '''Description / PK / Index
		
|- valign="top"
| CountryRegionCode
| nvarchar(3)
| not null
| 
| ISO standard code for countries and regions.<br />PK_CountryRegion_CountryRegionCode
|- valign="top"
| Name
| Name
| not null
| 
| Country or region name.<br />AK_CountryRegion_Name
|- valign="top"
| ModifiedDate
| datetime
| not null
| (GETDATE())
| Date and time the record was last updated.<br />
|}



{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Detail Table
| '''Column
| '''Referencing Column
		
|-
| [[Sales.CountryRegionCurrency_(table)|Sales.CountryRegionCurrency]]
| CountryRegionCode
| CountryRegionCode
|-
| [[Person.StateProvince_(table)|Person.StateProvince]]
| 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]]

|}