From dbscript Online Help
wikibot[edit]
| Table
|
Sales.CountryRegionCurrency
|
| Description
|
Cross-reference table mapping ISO currency codes to a country or region.
|
Columns[edit]
| Column
|
Data Type
|
Nullable
|
Default
|
Description
|
| 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
|
not null
|
(getdate())
|
Date and time the record was last updated.
|
Primary Key[edit]
| Primary Key
|
Columns
|
| PK_CountryRegionCurrency_CountryRegionCode_CurrencyCode
|
CountryRegionCode, CurrencyCode
|
Indexes[edit]
| Index
|
Type
|
Columns
|
| IX_CountryRegionCurrency_CurrencyCode
|
|
CurrencyCode
|
Foreign Keys[edit]
References[edit]
| Dependency Type
|
Object Type
|
Referenced Object
|
| Schema
|
Schema
|
Sales
|
automatically generated[edit]
| 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.
|
| Dependency Type
|
Object Type
|
Referenced Object
|
| Schema
|
Schema
|
Sales
|
