AdventureWorks
| Table Name: | Sales.Currency |
| Description: | Lookup table containing standard ISO currencies. |
| Primary Keys: | CurrencyCode |
| Field | Type | Defaults | Nulls? | Comments |
|---|---|---|---|---|
| CurrencyCode | nchar (3) | None | No | The ISO code for the Currency. |
| Name | nvarchar (50) | None | No | Currency name. |
| ModifiedDate | datetime | (getdate()) | No | Date and time the record was last updated. |
| Index | Clustered? | Unique? | Fields |
|---|---|---|---|
| PK_Currency_CurrencyCode | Yes | Yes | CurrencyCode |
| AK_Currency_Name | No | Yes | Name |
| Primary Key as Foreign Key Constraint | Affected Table | Affected Field |
|---|---|---|
| FK_CountryRegionCurrency_Currency_CurrencyCode | Sales.CountryRegionCurrency | CurrencyCode |
| FK_CurrencyRate_Currency_FromCurrencyCode | Sales.CurrencyRate | FromCurrencyCode |
| FK_CurrencyRate_Currency_ToCurrencyCode | Sales.CurrencyRate | ToCurrencyCode |