Table: CountryRegionCurrency Table: CountryRegionCurrency| 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 |
| Name | Value |
|---|---|
| MS_Description | Cross-reference table mapping ISO currency codes to a country or region. |
| Column ID | Column Name | Datatype | Nullable | Is Sparse | Is Column Set |
|---|---|---|---|---|---|
| 1 | CountryRegionCode | nvarchar(3) |
|
|
|
| 2 | CurrencyCode | nchar(3) |
|
|
|
| 3 | ModifiedDate | datetime |
|
|
|
| Name | Is System Named | Extended Property Name | Extended Property Value |
|---|---|---|---|
| PK_CountryRegionCurrency_CountryRegionCode_CurrencyCode |
|
MS_Description | Primary key (clustered) constraint |
| Name |
|---|
| CountryRegionCode |
| CurrencyCode |
| 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 |
| Name | Column | Definition | Is System Named | Extended Property Name | Extended Property Value |
|---|---|---|---|---|---|
| DF_CountryRegionCurrency_ModifiedDate | ModifiedDate | (getdate()) |
|
MS_Description | Default constraint value of GETDATE() |
| Name | Index Type | Primary Key | Unique | Unique Constraint | Ignore Duplicate Key | Disabled |
|---|---|---|---|---|---|---|
| PK_CountryRegionCurrency_CountryRegionCode_CurrencyCode | CLUSTERED |
|
|
|
|
|
| IX_CountryRegionCurrency_CurrencyCode | NONCLUSTERED |
|
|
|
|
|
| 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 |
| All Density | Average Length | Columns |
|---|---|---|
| 0.01041667 | 4 | CountryRegionCode |
| 0.009174312 | 10 | CountryRegionCode, CurrencyCode |
| 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 |
| 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 |
| All Density | Average Length | Columns |
|---|---|---|
| 0.01030928 | 6 | CurrencyCode |
| 0.009174312 | 10 | CurrencyCode, CountryRegionCode |
| 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 |
| 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' |