Owner: Sales 
Creation Date: 04/26/2006 
Located On: PRIMARY 
Data Size KB:
Index Size KB: 24 
Rows: 109 
Description: Cross-reference table mapping ISO currency codes to a country or region. 


Name Data Type Length NULL Default IsIdentity IsGUID Description
    CountryRegionCode  nvarchar          ISO code for countries and regions. Foreign key to CountryRegion.CountryRegionCode. 
    CurrencyCode  nchar          ISO standard currency code. Foreign key to Currency.CurrencyCode. 
    ModifiedDate  datetime    (getdate())      Date and time the record was last updated. 
Total: 3 column(s)


Index Primary Unique Description
  PK_CountryRegionCurrency_CountryRegionCode_CurrencyCode      Primary key (clustered) constraint 
  IX_CountryRegionCurrency_CurrencyCode      Nonclustered index. 
Total: 2 index(es)

Referenced Tables

Table Foreign Key Primary Key or Unique Constraint
  Person.CountryRegion  FK_CountryRegionCurrency_CountryRegion_CountryRegionCode  PK_CountryRegion_CountryRegionCode 
  Sales.Currency  FK_CountryRegionCurrency_Currency_CurrencyCode  PK_Currency_CurrencyCode 
Total: 2 table(s)

Objects that [Sales].[CountryRegionCurrency] depends on

Object Name Owner Object Type Dep Level
  Name  dbo  User Defined type 
  CountryRegion  Person  Table 
  Currency  Sales  Table 
Total: 3 object(s)


CREATE TABLE [CountryRegionCurrency] (
    [CountryRegionCode] [nvarchar] (3) COLLATE Latin1_General_CS_AS NOT NULL ,
    [CurrencyCode] [nchar] (3) COLLATE Latin1_General_CS_AS NOT NULL ,
    [ModifiedDate] [datetime] NOT NULL CONSTRAINT [DF_CountryRegionCurrency_ModifiedDate] DEFAULT (getdate()),
    CONSTRAINT [PK_CountryRegionCurrency_CountryRegionCode_CurrencyCode] PRIMARY KEY  CLUSTERED
    )  ON [PRIMARY] ,
    CONSTRAINT [FK_CountryRegionCurrency_CountryRegion_CountryRegionCode] FOREIGN KEY
    ) REFERENCES [CountryRegion] (
    CONSTRAINT [FK_CountryRegionCurrency_Currency_CurrencyCode] FOREIGN KEY
    ) REFERENCES [Currency] (

See Also

List of tables