AdventureWorks

Basic Index   Expanded Index

Table Name:Sales.Currency
Description:Lookup table containing standard ISO currencies.
Primary Keys:CurrencyCode
FieldTypeDefaultsNulls?Comments
CurrencyCodenchar (3)NoneNoThe ISO code for the Currency.
Namenvarchar (50)NoneNoCurrency name.
ModifiedDatedatetime(getdate())NoDate and time the record was last updated.

IndexClustered?Unique?Fields
PK_Currency_CurrencyCodeYesYesCurrencyCode
AK_Currency_NameNoYesName

No check constraints
No internal foreign key constraints
Primary Key as Foreign Key ConstraintAffected TableAffected Field
FK_CountryRegionCurrency_Currency_CurrencyCodeSales.CountryRegionCurrencyCurrencyCode
FK_CurrencyRate_Currency_FromCurrencyCodeSales.CurrencyRateFromCurrencyCode
FK_CurrencyRate_Currency_ToCurrencyCodeSales.CurrencyRateToCurrencyCode

No triggers