Object type: Table

Lookup table containing standard ISO currencies.

Columns 

Name	Data type	Nullable	Description
CurrencyCode	nchar(3)	No	The ISO code for the Currency.
Name	Name	No	Currency name.
ModifiedDate	datetime	No	Default value: GETDATE() Date and time the record was last updated.

Constraints 

Name	Type	Columns	Description
DF_Currency_ModifiedDate	DEFAULT	ModifiedDate	Value: GETDATE() Default constraint value of GETDATE()
PK_Currency_CurrencyCode	PRIMARY KEY	CurrencyCode	Clustered index created by a primary key constraint.

Indices 

Name	Description
AK_Currency_Name	Unique nonclustered index.

Triggers 

Name	Description
Sales.uCurrency	AFTER UPDATE trigger setting the ModifiedDate column in the Currency table to the current date.

Linked tables 

Name	Description
Sales.CountryRegionCurrency	Cross-reference table mapping ISO currency codes to a country or region.
Sales.CurrencyRate	Currency exchange rates.

Modified by 

Name	Description
Sales.uCurrency	AFTER UPDATE trigger setting the ModifiedDate column in the Currency table to the current date.

Applies to

Tables | User

The AdventureWorks database sample was developed by Microsoft Corporation, copyright 2005. SQL Server is a trademark of Microsoft Corporation