Properties

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

Columns

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

Total: 3 column(s)

Indexes

	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	1
	CountryRegion	Person	Table	2
	Currency	Sales	Table	2

Total: 3 object(s)

SQL

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
    (
        [CountryRegionCode],
        [CurrencyCode]
    )  ON [PRIMARY] ,
    CONSTRAINT [FK_CountryRegionCurrency_CountryRegion_CountryRegionCode] FOREIGN KEY
    (
        [CountryRegionCode]
    ) REFERENCES [CountryRegion] (
        [CountryRegionCode]
    ),
    CONSTRAINT [FK_CountryRegionCurrency_Currency_CurrencyCode] FOREIGN KEY
    (
        [CurrencyCode]
    ) REFERENCES [Currency] (
        [CurrencyCode]
    )
) ON [PRIMARY]
GO

See Also

List of tables