Sales.CountryRegionCurrency

Table: 'Sales.CountryRegionCurrency'

3 fields. 28 bytes.

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

Field Name	Data Type	Size	Original Type	Default	Nullable	Description	Check
CountryRegionCode	nvarchar	3			Not null	ISO code for countries and regions. Foreign key to CountryRegion.CountryRegionCode.
CurrencyCode	nchar	3			Not null	ISO standard currency code. Foreign key to Currency.CurrencyCode.
ModifiedDate	datetime			getdate()	Not null	Date and time the record was last updated.

Extended Properties

The object has no extended properties.

Primary key for table 'Sales.CountryRegionCurrency'

Primary Key Name	Field Names
PK_CountryRegionCurrency_CountryRegionCode_CurrencyCode	CountryRegionCode, CurrencyCode

Foreign keys for table 'Sales.CountryRegionCurrency', 2 items

Foreign	Primary	Key Name
CountryRegionCurrency.CountryRegionCode	CountryRegion.CountryRegionCode	FK_CountryRegionCurrency_CountryRegion_CountryRegionCode
CountryRegionCurrency.CurrencyCode	Currency.CurrencyCode	FK_CountryRegionCurrency_Currency_CurrencyCode

Indexes for table 'Sales.CountryRegionCurrency', 2 items

Index Name	Description	Clustered	Unique	Fields
PK_CountryRegionCurrency_CountryRegionCode_CurrencyCode	Clustered index created by a primary key constraint.	Yes	Yes	CountryRegionCode, CurrencyCode
IX_CountryRegionCurrency_CurrencyCode	Nonclustered index.	No	No	CurrencyCode

Triggers for table 'Sales.CountryRegionCurrency', 1 item

Name	Description	Type	Enabled
uCountryRegionCurrency	AFTER UPDATE trigger setting the ModifiedDate column in the CountryRegionCurrency table to the current date.	after Update	Yes

Dependencies for table 'Sales.CountryRegionCurrency', 1 item

Object Name	Type	Field Name
Sales.uCountryRegionCurrency	trigger	N/A