Person.CountryRegion

Object type: Table

Lookup table containing the ISO standard codes for countries and regions.

Columns

Name Data type Nullable Description

CountryRegionCode nvarchar(3) No ISO standard code for countries and regions.

Name Name No Country or region name.

ModifiedDate datetime No Default value: GETDATE()
Date and time the record was last updated.

Constraints

Name Type Columns Description

DF_CountryRegion_ModifiedDate DEFAULT ModifiedDate Value: GETDATE()
Default constraint value of GETDATE()

PK_CountryRegion_CountryRegionCode PRIMARY KEY CountryRegionCode Clustered index created by a primary key constraint.

Indices

Name Description

AK_CountryRegion_Name Unique nonclustered index.

Triggers

Name Description

Person.uCountryRegion AFTER UPDATE trigger setting the ModifiedDate column in the CountryRegion table to the current date.

Linked tables

Name Description

Person.StateProvince State and province lookup table.

Sales.CountryRegionCurrency Cross-reference table mapping ISO currency codes to a country or region.

Accessed by

Name Description

HumanResources.vEmployee Employee names and addresses.

Person.vStateProvinceCountryRegion Joins StateProvince table with CountryRegion table.

Purchasing.vVendor Vendor (company) names and addresses and the names of vendor employees to contact.

Sales Order Detail Detail of an individual Adventure Works order. This report can be accessed as a drillthrough report from the Employee Sales Summary and Territory Sales drilldown report. This report illustrates the use of lists, tables, parameters, and expressions.

Sales.vIndividual Individual customers (names and addresses) that purchase Adventure Works Cycles products online.

Sales.vSalesPerson Sales representiatives (names and addresses) and their sales-related information.

Sales.vStoreWithDemographics Stores (names and addresses) that sell Adventure Works Cycles products to consumers.

Modified by

Name Description

Person.uCountryRegion AFTER UPDATE trigger setting the ModifiedDate column in the CountryRegion table to the current date.

Applies to

Tables | User

Name	Data type	Nullable	Description
CountryRegionCode	nvarchar(3)	No	ISO standard code for countries and regions.
Name	Name	No	Country or region name.
ModifiedDate	datetime	No	Default value: GETDATE() Date and time the record was last updated.

Name	Type	Columns	Description
DF_CountryRegion_ModifiedDate	DEFAULT	ModifiedDate	Value: GETDATE() Default constraint value of GETDATE()
PK_CountryRegion_CountryRegionCode	PRIMARY KEY	CountryRegionCode	Clustered index created by a primary key constraint.

Name	Description
AK_CountryRegion_Name	Unique nonclustered index.

Name	Description
Person.uCountryRegion	AFTER UPDATE trigger setting the ModifiedDate column in the CountryRegion table to the current date.

Name	Description
Person.StateProvince	State and province lookup table.
Sales.CountryRegionCurrency	Cross-reference table mapping ISO currency codes to a country or region.

Name	Description
HumanResources.vEmployee	Employee names and addresses.
Person.vStateProvinceCountryRegion	Joins StateProvince table with CountryRegion table.
Purchasing.vVendor	Vendor (company) names and addresses and the names of vendor employees to contact.
Sales Order Detail	Detail of an individual Adventure Works order. This report can be accessed as a drillthrough report from the Employee Sales Summary and Territory Sales drilldown report. This report illustrates the use of lists, tables, parameters, and expressions.
Sales.vIndividual	Individual customers (names and addresses) that purchase Adventure Works Cycles products online.
Sales.vSalesPerson	Sales representiatives (names and addresses) and their sales-related information.
Sales.vStoreWithDemographics	Stores (names and addresses) that sell Adventure Works Cycles products to consumers.