Databases > AdventureWorks2019 > Tables > Sales.CountryRegionCurrency

AdventureWorks2019

Sales.CountryRegionCurrency

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

Created: Modified:

Columns

  • //
    ${escapify(column.description)}
    CountryRegionCode
    [nvarchar](3) NOT NULL
  • //
    ${escapify(column.description)}
    CurrencyCode
    [nchar](3) NOT NULL
  • //
    ${escapify(column.description)}
    ModifiedDate
    [datetime] NOT NULL DEFAULT (getdate())

Indexes

  • //
    Clustered index created by a primary key constraint.
    PK_CountryRegionCurrency_CountryRegionCode_CurrencyCode
    UNIQUE CLUSTERED
    CountryRegionCode , CurrencyCode
  • //
    Nonclustered index.
    IX_CountryRegionCurrency_CurrencyCode
    NONCLUSTERED
    CurrencyCode

Foreign Keys

  • //
    Foreign key constraint referencing CountryRegion.CountryRegionCode.
    FK_CountryRegionCurrency_CountryRegion_CountryRegionCode
    Person.CountryRegion
    CountryRegionCode ⥱ CountryRegionCode
  • //
    Foreign key constraint referencing Currency.CurrencyCode.
    FK_CountryRegionCurrency_Currency_CurrencyCode
    Sales.Currency
    CurrencyCode ⥱ CurrencyCode

Sample Data

CountryRegionCode
CurrencyCode
ModifiedDate
AE
AED
AR
ARS
AT
ATS
AT
EUR
AU
AUD
BB
BBD
BD
BDT
BE
BEF
BE
EUR
BG
BGN
BH
BHD
BN
BND
BO
BOB
BR
BRL
BS
BSD
BT
BTN
CA
CAD
CH
CHF
CL
CLP
CN
CNY
CO
COP
CR
CRC
CY
CYP
CZ
CZK
DE
DEM