CountryRegionCurrency Table (AdventureWorks)

Maps International Standards Organization (ISO) currency codes to a country or region.

CountryRegionCurrency Table Definition

The CountryRegionCurrency table is contained in the Sales schema.

Column Data type Nullability Description

CountryRegionCode

nvarchar(3)

Not null

Standard code for countries or regions. Foreign key to CountryRegion.CountryRegionCode

CurrencyCode

nchar(3)

Not null

ISO currency code. Foreign key to Currency.CurrencyCode.

ModifiedDate

datetime

Not null

Date and time the row was last updated.

See Also

Reference

CountryRegion Table (AdventureWorks)
Currency Table (AdventureWorks)
CurrencyRate Table (AdventureWorks)

Other Resources

AdventureWorks Data Dictionary

Help and Information

Getting SQL Server 2005 Assistance