# Table: CountryRegionCurrency

## Properties

Property | Value
--- | ---
Name | CountryRegionCurrency
ID | 517576882
Owner | dbo
Schema | Sales
Filegroup | PRIMARY
Data Size (KB) | 8 KB
Index Size (KB) | 24 KB
Rows | 109
Unused (KB) | 0 KB
ANSI Null On |
Quoted Identifier |
Lock Escalation | TABLE
Lock On Bulk Load |
Lob Data Space |
Filestream Data Space ID |
Has Unchecked Assembly Data |
Text In Row Limit (bytes) | Option not set
Large Value Types Out Of Row |
FullText Change Tracking On |
Tracked By Cdc |
Published |
Schema Published |
Replicated |
Replication Filter |
Merge Published |
Sync Tran Subscribed |
MS Shipped |
Modify Date | 8/8/2010 5:23:39 PM
Create Date | 8/8/2010 5:21:47 PM

## Extended Properties

Name | Value
--- | ---
MS_Description | Cross-reference table mapping ISO currency codes to a country or region.

## Columns

Column ID | Column Name | Datatype | Nullable | Is Sparse | Is Column Set
--- | --- | --- | --- | --- | ---
1 | CountryRegionCode | nvarchar(3) |  |  |
2 | CurrencyCode | nchar(3) |  |  |
3 | ModifiedDate | datetime |  |  |

## Identity Columns

No identity columns defined.

## Primary Key Constraints

Name | Is System Named | Extended Property Name | Extended Property Value
--- | --- | --- | ---
PK_CountryRegionCurrency_CountryRegionCode_CurrencyCode |  | MS_Description | Primary key (clustered) constraint

## Primary Key Columns

Name
CountryRegionCode
CurrencyCode

## Foreign Keys

Name | Referenced Object | Update Action | Delete Action
--- | --- | --- | ---
FK_CountryRegionCurrency_CountryRegion_CountryRegionCode | Person.CountryRegion | No action | No action
FK_CountryRegionCurrency_Currency_CurrencyCode | Sales.Currency | No action | No action

## Column Level Check Constraints

No column constraints defined.

## Table Level Check Constraints

No table constraints defined.

## Default Constraints

Name | Column | Definition | Is System Named | Extended Property Name | Extended Property Value
--- | --- | --- | --- | --- | ---
DF_CountryRegionCurrency_ModifiedDate | ModifiedDate | (getdate()) |  | MS_Description | Default constraint value of GETDATE()

## Indexes

Name | Index Type | Primary Key | Unique | Unique Constraint | Ignore Duplicate Key | Disabled
--- | --- | --- | --- | --- | --- | ---
PK_CountryRegionCurrency_CountryRegionCode_CurrencyCode | CLUSTERED |  |  |  |  |
IX_CountryRegionCurrency_CurrencyCode | NONCLUSTERED |  |  |  |  |

## FullText Indexes

No fulltext indexes defined.

## Referencing Tables

No referencing tables defined.

## Object Level Permissions

No object level permissions defined.

## Column Level Permissions

No explicit column permissions granted to this object

## Statistics

### Detailed Statistics General

Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows
--- | --- | --- | --- | --- | --- | --- | --- | --- | ---
PK_CountryRegionCurrency_CountryRegionCode_CurrencyCode | Aug 8 2010 5:22PM | 109 | 109 | 91 | 1 | 10 |  |  | 109

### Detailed Statistics Density

All Density | Average Length | Columns
--- | --- | ---
0.01041667 | 4 | CountryRegionCode
0.009174312 | 10 | CountryRegionCode, CurrencyCode

### Detailed Statistics Histogram

Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows
--- | --- | --- | --- | ---
AE | 0 | 1 | 0 | 1
AR | 0 | 1 | 0 | 1
AT | 0 | 2 | 0 | 1
AU | 0 | 1 | 0 | 1
BB | 0 | 1 | 0 | 1
BD | 0 | 1 | 0 | 1
BE | 0 | 2 | 0 | 1
BG | 0 | 1 | 0 | 1
BH | 0 | 1 | 0 | 1
BN | 0 | 1 | 0 | 1
BR | 1 | 1 | 1 | 1
BT | 1 | 1 | 1 | 1
CA | 0 | 1 | 0 | 1
CH | 0 | 1 | 0 | 1
CL | 0 | 1 | 0 | 1
CN | 0 | 1 | 0 | 1
CR | 1 | 1 | 1 | 1
CY | 0 | 1 | 0 | 1
CZ | 0 | 1 | 0 | 1
DE | 0 | 2 | 0 | 1
DK | 0 | 1 | 0 | 1
DO | 0 | 1 | 0 | 1
DZ | 0 | 1 | 0 | 1
EC | 0 | 1 | 0 | 1
EE | 0 | 1 | 0 | 1
EG | 0 | 1 | 0 | 1
ES | 0 | 2 | 0 | 1
FI | 0 | 2 | 0 | 1
FJ | 0 | 1 | 0 | 1
FR | 0 | 2 | 0 | 1
GB | 0 | 1 | 0 | 1
GH | 0 | 1 | 0 | 1
GR | 0 | 2 | 0 | 1
GT | 0 | 1 | 0 | 1
HK | 0 | 1 | 0 | 1
HR | 0 | 1 | 0 | 1
HU | 0 | 1 | 0 | 1
ID | 0 | 1 | 0 | 1
IE | 0 | 2 | 0 | 1
IN | 1 | 1 | 1 | 1
IS | 0 | 1 | 0 | 1
IT | 0 | 2 | 0 | 1
JM | 0 | 1 | 0 | 1
JO | 0 | 1 | 0 | 1
JP | 0 | 1 | 0 | 1
KE | 0 | 1 | 0 | 1
KR | 0 | 1 | 0 | 1
KW | 0 | 1 | 0 | 1
LB | 0 | 1 | 0 | 1
LK | 0 | 1 | 0 | 1
LT | 0 | 1 | 0 | 1
LU | 0 | 1 | 0 | 1
LV | 0 | 1 | 0 | 1
MA | 0 | 1 | 0 | 1
MT | 0 | 1 | 0 | 1
MU | 0 | 1 | 0 | 1
MV | 0 | 1 | 0 | 1
MX | 0 | 1 | 0 | 1
MY | 0 | 1 | 0 | 1
NA | 0 | 1 | 0 | 1
NG | 0 | 1 | 0 | 1
NL | 0 | 2 | 0 | 1
NO | 0 | 1 | 0 | 1
NP | 0 | 1 | 0 | 1
NZ | 0 | 1 | 0 | 1
OM | 0 | 1 | 0 | 1
PA | 0 | 1 | 0 | 1
PE | 0 | 1 | 0 | 1
PK | 1 | 1 | 1 | 1
PL | 0 | 2 | 0 | 1
PT | 0 | 2 | 0 | 1
PY | 0 | 1 | 0 | 1
RO | 0 | 1 | 0 | 1
RU | 0 | 2 | 0 | 1
SA | 0 | 1 | 0 | 1
SE | 0 | 1 | 0 | 1
SG | 0 | 1 | 0 | 1
SI | 0 | 1 | 0 | 1
SK | 0 | 1 | 0 | 1
SV | 0 | 1 | 0 | 1
TH | 0 | 1 | 0 | 1
TN | 0 | 1 | 0 | 1
TR | 0 | 1 | 0 | 1
TT | 0 | 1 | 0 | 1
TW | 0 | 1 | 0 | 1
US | 0 | 1 | 0 | 1
UY | 0 | 1 | 0 | 1
VE | 0 | 1 | 0 | 1
VN | 0 | 1 | 0 | 1
ZA | 0 | 1 | 0 | 1
ZW | 0 | 1 | 0 | 1

### Detailed Statistics General

Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows
--- | --- | --- | --- | --- | --- | --- | --- | --- | ---
IX_CountryRegionCurrency_CurrencyCode | Aug 8 2010 5:23PM | 109 | 109 | 91 | 1 | 10 |  |  | 109

### Detailed Statistics Density

All Density | Average Length | Columns
--- | --- | ---
0.01030928 | 6 | CurrencyCode
0.009174312 | 10 | CurrencyCode, CountryRegionCode

### Detailed Statistics Histogram

Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows
--- | --- | --- | --- | ---
AED | 0 | 1 | 0 | 1
ARS | 0 | 1 | 0 | 1
ATS | 0 | 1 | 0 | 1
AUD | 0 | 1 | 0 | 1
BBD | 0 | 1 | 0 | 1
BDT | 0 | 1 | 0 | 1
BEF | 0 | 1 | 0 | 1
BGN | 0 | 1 | 0 | 1
BHD | 0 | 1 | 0 | 1
BND | 0 | 1 | 0 | 1
BRL | 1 | 1 | 1 | 1
BTN | 1 | 1 | 1 | 1
CAD | 0 | 1 | 0 | 1
CHF | 0 | 1 | 0 | 1
CLP | 0 | 1 | 0 | 1
CNY | 0 | 1 | 0 | 1
CRC | 1 | 1 | 1 | 1
CYP | 0 | 1 | 0 | 1
CZK | 0 | 1 | 0 | 1
DEM | 0 | 1 | 0 | 1
DKK | 0 | 1 | 0 | 1
DOP | 0 | 1 | 0 | 1
DZD | 0 | 1 | 0 | 1
EEK | 0 | 1 | 0 | 1
EGP | 0 | 1 | 0 | 1
ESP | 0 | 1 | 0 | 1
EUR | 0 | 12 | 0 | 1
FIM | 0 | 1 | 0 | 1
FJD | 0 | 1 | 0 | 1
FRF | 0 | 1 | 0 | 1
GBP | 0 | 1 | 0 | 1
GHC | 0 | 1 | 0 | 1
GRD | 0 | 1 | 0 | 1
GTQ | 0 | 1 | 0 | 1
HKD | 0 | 1 | 0 | 1
HRK | 0 | 1 | 0 | 1
HUF | 0 | 1 | 0 | 1
IDR | 0 | 1 | 0 | 1
IEP | 0 | 1 | 0 | 1
INR | 1 | 1 | 1 | 1
ISK | 0 | 1 | 0 | 1
ITL | 0 | 1 | 0 | 1
JMD | 0 | 1 | 0 | 1
JOD | 0 | 1 | 0 | 1
JPY | 0 | 1 | 0 | 1
KES | 0 | 1 | 0 | 1
KRW | 0 | 1 | 0 | 1
KWD | 0 | 1 | 0 | 1
LBP | 0 | 1 | 0 | 1
LKR | 0 | 1 | 0 | 1
LTL | 0 | 1 | 0 | 1
LVL | 0 | 1 | 0 | 1
MAD | 0 | 1 | 0 | 1
MTL | 0 | 1 | 0 | 1
MUR | 0 | 1 | 0 | 1
MVR | 0 | 1 | 0 | 1
MXN | 0 | 1 | 0 | 1
MYR | 0 | 1 | 0 | 1
NAD | 0 | 1 | 0 | 1
NLG | 1 | 1 | 1 | 1
NOK | 0 | 1 | 0 | 1
NPR | 0 | 1 | 0 | 1
NZD | 0 | 1 | 0 | 1
OMR | 0 | 1 | 0 | 1
PAB | 0 | 1 | 0 | 1
PEN | 0 | 1 | 0 | 1
PKR | 1 | 1 | 1 | 1
PLN | 0 | 1 | 0 | 1
PLZ | 0 | 1 | 0 | 1
PTE | 0 | 1 | 0 | 1
PYG | 0 | 1 | 0 | 1
ROL | 0 | 1 | 0 | 1
RUB | 0 | 1 | 0 | 1
RUR | 0 | 1 | 0 | 1
SAR | 0 | 1 | 0 | 1
SEK | 0 | 1 | 0 | 1
SGD | 0 | 1 | 0 | 1
SIT | 0 | 1 | 0 | 1
SKK | 0 | 1 | 0 | 1
SVC | 0 | 1 | 0 | 1
THB | 0 | 1 | 0 | 1
TND | 0 | 1 | 0 | 1
TRL | 0 | 1 | 0 | 1
TTD | 0 | 1 | 0 | 1
TWD | 0 | 1 | 0 | 1
USD | 0 | 2 | 0 | 1
UYU | 0 | 1 | 0 | 1
VEB | 0 | 1 | 0 | 1
VND | 0 | 1 | 0 | 1
ZAR | 0 | 1 | 0 | 1
ZWD | 0 | 1 | 0 | 1

## Objects that depend on [CountryRegionCurrency]

- Sales.CountryRegionCurrency

## Objects on which [CountryRegionCurrency] depends

- Sales.CountryRegionCurrency
  - Sales.Currency
    - dbo.Name
  - Person.CountryRegion

## SQL

Script
SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [Sales].[CountryRegionCurrency]( [CountryRegionCode] [nvarchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [CurrencyCode] [nchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [ModifiedDate] [datetime] NOT NULL ) ON [PRIMARY] EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ISO code for countries and regions. Foreign key to CountryRegion.CountryRegionCode.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'CountryRegionCurrency', @level2type=N'COLUMN',@level2name=N'CountryRegionCode' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ISO standard currency code. Foreign key to Currency.CurrencyCode.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'CountryRegionCurrency', @level2type=N'COLUMN',@level2name=N'CurrencyCode' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date and time the record was last updated.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'CountryRegionCurrency', @level2type=N'COLUMN',@level2name=N'ModifiedDate' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Cross-reference table mapping ISO currency codes to a country or region.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'CountryRegionCurrency'

#### See also

List of Tables