Databases > AdventureWorks2019 > Tables > Sales.Currency

AdventureWorks2019

Sales.Currency

//
Lookup table containing standard ISO currencies.

Created: Modified:

Columns

  • //
    ${escapify(column.description)}
    CurrencyCode
    [nchar](3) NOT NULL
  • //
    ${escapify(column.description)}
    Name
    [Name] NOT NULL
    //
    USER-DEFINED DATA TYPE
    [nvarchar](50) NULL
  • //
    ${escapify(column.description)}
    ModifiedDate
    [datetime] NOT NULL DEFAULT (getdate())

Indexes

  • //
    Clustered index created by a primary key constraint.
    PK_Currency_CurrencyCode
    UNIQUE CLUSTERED
    CurrencyCode
  • //
    Unique nonclustered index.
    AK_Currency_Name
    UNIQUE NONCLUSTERED
    Name

Sample Data

CurrencyCode
Name
ModifiedDate
AED
Emirati Dirham
AFA
Afghani
ALL
Lek
AMD
Armenian Dram
ANG
Netherlands Antillian Guilder
AOA
Kwanza
ARS
Argentine Peso
ATS
Shilling
AUD
Australian Dollar
AWG
Aruban Guilder
AZM
Azerbaijanian Manat
BBD
Barbados Dollar
BDT
Taka
BEF
Belgian Franc
BGN
Bulgarian Lev
BHD
Bahraini Dinar
BND
Brunei Dollar
BOB
Boliviano
BRL
Brazilian Real
BSD
Bahamian Dollar
BTN
Ngultrum
CAD
Canadian Dollar
CHF
Swiss Franc
CLP
Chilean Peso
CNY
Yuan Renminbi