From dbscript Online Help
wikibot
Table
|
Sales.CountryRegionCurrency
|
Column
|
Data Type
|
Nullable
|
Default
|
PK
|
Index
|
CountryRegionCode
|
nvarchar(3)
|
not null
|
|
PK_CountryRegionCurrency_CountryRegionCode_CurrencyCode
|
|
CurrencyCode
|
nchar(3)
|
not null
|
|
PK_CountryRegionCurrency_CountryRegionCode_CurrencyCode
|
IX_CountryRegionCurrency_CurrencyCode
|
ModifiedDate
|
datetime
|
not null
|
(getdate())
|
|
|
automatically generated
Table
|
Sales.CountryRegionCurrency
|
Description
|
Cross-reference table mapping ISO currency codes to a country or region.
|
Column
|
Data Type
|
Nullable
|
Default
|
Description / PK / Index
|
CountryRegionCode
|
nvarchar(3)
|
not null
|
|
ISO code for countries and regions. Foreign key to CountryRegion.CountryRegionCode.PK_CountryRegionCurrency_CountryRegionCode_CurrencyCode
|
CurrencyCode
|
nchar(3)
|
not null
|
|
ISO standard currency code. Foreign key to Currency.CurrencyCode.PK_CountryRegionCurrency_CountryRegionCode_CurrencyCodeIX_CountryRegionCurrency_CurrencyCode
|
ModifiedDate
|
datetime
|
not null
|
(GETDATE())
|
Date and time the record was last updated.
|