Sales.CountryRegionCurrency Table

Information

Name	CountryRegionCurrency
Schema	Sales
Row Count	0
Data Size
Index Size
Reserved Size
Unused Size
Created	29.3.2010. 21:58:18
Modified	29.3.2010. 21:58:54

Extended Properties

Name	Type	Property Name	Value
CountryRegionCurrency	TABLE	MS_Description	Cross-reference table mapping ISO currency codes to a country or region.

Columns

Name	Data Type	Collation	References	Default
CountryRegionCode	nvarchar(3)	SQL_Latin1_General_CP1_CI_AS	Person.CountryRegion.CountryRegionCode
CurrencyCode	nchar(3)	SQL_Latin1_General_CP1_CI_AS	Sales.Currency.CurrencyCode
ModifiedDate	datetime			(getdate())

Indexes

Name	Type	Primary	Unique	Columns
PK_CountryRegionCurrency_CountryRegionCode_CurrencyCode	Clustered			CountryRegionCode, CurrencyCode
IX_CountryRegionCurrency_CurrencyCode	NonClustered			CurrencyCode

Foreign Key Constraints

Name	Type	Referenced Table
FK_CountryRegionCurrency_CountryRegion_CountryRegionCode	Foreign key	Person.CountryRegion
FK_CountryRegionCurrency_Currency_CurrencyCode	Foreign key	Sales.Currency

SQL Script

CREATE TABLE [Sales].[CountryRegionCurrency] (
    [CountryRegionCode] nvarchar(3) NOT NULL,
    [CurrencyCode] nchar(3) NOT NULL,
    [ModifiedDate] datetime NOT NULL DEFAULT (getdate())
);
CREATE INDEX [IX_CountryRegionCurrency_CurrencyCode] on [Sales].[CountryRegionCurrency]([CurrencyCode]);