Table: Currency

Properties

Property	Value
Name	Currency
ID	645577338
Owner	dbo
Schema	Sales
Filegroup	PRIMARY
Data Size (KB)	8 KB
Index Size (KB)	24 KB
Rows	105
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	Lookup table containing standard ISO currencies.

Columns

Column ID	Column Name	Datatype
1	CurrencyCode	nchar(3)
2	Name	Name
3	ModifiedDate	datetime

Identity Columns

No identity columns defined.

Primary Key Constraints

Name	Is System Named	Extended Property Name	Extended Property Value
PK_Currency_CurrencyCode		MS_Description	Primary key (clustered) constraint

Primary Key Columns

Name
CurrencyCode

Foreign Keys

No foreign keys defined.

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_Currency_ModifiedDate	ModifiedDate	(getdate())		MS_Description	Default constraint value of GETDATE()

Indexes

Name	Index Type	Primary Key	Unique	Unique Constraint	Ignore Duplicate Key	Disabled
PK_Currency_CurrencyCode	CLUSTERED
AK_Currency_Name	NONCLUSTERED

FullText Indexes

No fulltext indexes defined.

Referencing Tables

Name	Key Index ID	Delete Action	Update Action	Referencing Object
FK_CountryRegionCurrency_Currency_CurrencyCode	1	No action	No action	Sales.CountryRegionCurrency
FK_CurrencyRate_Currency_FromCurrencyCode	1	No action	No action	Sales.CurrencyRate
FK_CurrencyRate_Currency_ToCurrencyCode	1	No action	No action	Sales.CurrencyRate

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_Currency_CurrencyCode	Aug 8 2010 5:22PM	105	105	97	1	6			105

Detailed Statistics Density

All Density	Average Length	Columns
0.00952381	6	CurrencyCode

Detailed Statistics Histogram

Range High Key	Range Rows	Estimated Rows	Distinct Range Rows	Avg Range Rows
AED	0	1	0	1
AFA	0	1	0	1
ALL	0	1	0	1
AMD	0	1	0	1
ANG	0	1	0	1
AOA	0	1	0	1
ATS	1	1	1	1
AWG	1	1	1	1
AZM	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	1	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	1	0	1
UYU	0	1	0	1
VEB	0	1	0	1
VND	0	1	0	1
XOF	0	1	0	1
ZAR	0	1	0	1
ZWD	0	1	0	1

Detailed Statistics General

Name	Updated	Rows	Rows Sampled	Steps	Density	Average Key Length	String Index	Filter Expression	Unfiltered Rows
AK_Currency_Name	Aug 8 2010 5:23PM	105	105	105	0	30.13333			105

Detailed Statistics Density

All Density	Average Length	Columns
0.00952381	24.13333	Name
0.00952381	30.13333	Name, CurrencyCode

Detailed Statistics Histogram

Range High Key	Estimated Rows	Avg Range Rows
Afghani	1	1
Algerian Dinar	1	1
Argentine Peso	1	1
Armenian Dram	1	1
Aruban Guilder	1	1
Australian Dollar	1	1
Azerbaijanian Manat	1	1
Bahamian Dollar	1	1
Bahraini Dinar	1	1
Baht	1	1
Balboa	1	1
Barbados Dollar	1	1
Belgian Franc	1	1
Bolivar	1	1
Boliviano	1	1
Brazilian Real	1	1
Brunei Dollar	1	1
Bulgarian Lev	1	1
Canadian Dollar	1	1
Cedi	1	1
CFA Franc BCEAO	1	1
Chilean Peso	1	1
Colombian Peso	1	1
Costa Rican Colon	1	1
Croatian Kuna	1	1
Cyprus Pound	1	1
Czech Koruna	1	1
Danish Krone	1	1
Deutsche Mark	1	1
Dominican Peso	1	1
Dong	1	1
Drachma	1	1
Egyptian Pound	1	1
El Salvador Colon	1	1
Emirati Dirham	1	1
EURO	1	1
Fiji Dollar	1	1
Forint	1	1
French Franc	1	1
Guarani	1	1
Hong Kong Dollar	1	1
Iceland Krona	1	1
Indian Rupee	1	1
Irish Pound	1	1
Italian Lira	1	1
Jamaican Dollar	1	1
Jordanian Dinar	1	1
Kenyan Shilling	1	1
Kroon	1	1
Kuwaiti Dinar	1	1
Kwanza	1	1
Latvian Lats	1	1
Lebanese Pound	1	1
Lek	1	1
Leu	1	1
Lithuanian Litas	1	1
Malaysian Ringgit	1	1
Maltese Lira	1	1
Markka	1	1
Mauritius Rupee	1	1
Mexican Peso	1	1
Moroccan Dirham	1	1
Naira	1	1
Namibia Dollar	1	1
Nepalese Rupee	1	1
Netherlands Antillian Guilder	1	1
Netherlands Guilder	1	1
New Israeli Shekel	1	1
New Taiwan Dollar	1	1
New Zealand Dollar	1	1
Ngultrum	1	1
Norwegian Krone	1	1
Nuevo Sol	1	1
Omani Rial	1	1
Pakistan Rupee	1	1
Philippine Peso	1	1
Polish Zloty(old)	1	1
Portuguese Escudo	1	1
Quetzal	1	1
Rand	1	1
Rufiyaa	1	1
Rupiah	1	1
Russian Ruble	1	1
Russian Ruble(old)	1	1
Saudi Riyal	1	1
Shilling	1	1
Singapore Dollar	1	1
Slovak Koruna	1	1
Spanish Peseta	1	1
Sri Lankan Rupee	1	1
Swedish Krona	1	1
Swiss Franc	1	1
Taka	1	1
Tolar	1	1
Trinidad and Tobago Dollar	1	1
Tunisian Dinar	1	1
Turkish Lira	1	1
United Kingdom Pound	1	1
Uruguayan Peso	1	1
US Dollar	1	1
Won	1	1
Yen	1	1
Yuan Renminbi	1	1
Zimbabwe Dollar	1	1
Zloty	1	1

Objects that depend on [Currency]

Sales.Currency

Objects on which [Currency] depends

Sales.Currency
- dbo.Name

SQL

Script
SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [Sales].[Currency]( [CurrencyCode] [nchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [Name] [dbo].[Name] NOT NULL, [ModifiedDate] [datetime] NOT NULL ) ON [PRIMARY] EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The ISO code for the Currency.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'Currency', @level2type=N'COLUMN',@level2name=N'CurrencyCode' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Currency name.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'Currency', @level2type=N'COLUMN',@level2name=N'Name' 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'Currency', @level2type=N'COLUMN',@level2name=N'ModifiedDate' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Lookup table containing standard ISO currencies.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'Currency'

Script

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [Sales].[Currency]( [CurrencyCode] [nchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [Name] [dbo].[Name] NOT NULL, [ModifiedDate] [datetime] NOT NULL ) ON [PRIMARY]
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The ISO code for the Currency.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'Currency', @level2type=N'COLUMN',@level2name=N'CurrencyCode'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Currency name.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'Currency', @level2type=N'COLUMN',@level2name=N'Name'
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'Currency', @level2type=N'COLUMN',@level2name=N'ModifiedDate'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Lookup table containing standard ISO currencies.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'Currency'

Range High Key	Range Rows	Estimated Rows	Distinct Range Rows	Avg Range Rows
AED	0	1	0	1
AFA	0	1	0	1
ALL	0	1	0	1
AMD	0	1	0	1
ANG	0	1	0	1
AOA	0	1	0	1
ATS	1	1	1	1
AWG	1	1	1	1
AZM	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	1	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	1	0	1
UYU	0	1	0	1
VEB	0	1	0	1
VND	0	1	0	1
XOF	0	1	0	1
ZAR	0	1	0	1
ZWD	0	1	0	1

Range High Key	Range Rows	Estimated Rows	Distinct Range Rows	Avg Range Rows
AED	0	1	0	1
AFA	0	1	0	1
ALL	0	1	0	1
AMD	0	1	0	1
ANG	0	1	0	1
AOA	0	1	0	1
ATS	1	1	1	1
AWG	1	1	1	1
AZM	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	1	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	1	0	1
UYU	0	1	0	1
VEB	0	1	0	1
VND	0	1	0	1
XOF	0	1	0	1
ZAR	0	1	0	1
ZWD	0	1	0	1

Table: Currency

Properties

Extended Properties

Columns

Identity Columns

Primary Key Constraints

Primary Key Columns

Foreign Keys

Column Level Check Constraints

Table Level Check Constraints

Default Constraints

Indexes

FullText Indexes

Referencing Tables

Object Level Permissions

Column Level Permissions

Statistics

Detailed Statistics General

Detailed Statistics Density

Detailed Statistics Histogram

Detailed Statistics General

Detailed Statistics Density

Detailed Statistics Histogram

Objects that depend on [Currency]

Objects on which [Currency] depends

SQL

See also

Range High Key	Range Rows	Estimated Rows	Distinct Range Rows	Avg Range Rows
AED	0	1	0	1
AFA	0	1	0	1
ALL	0	1	0	1
AMD	0	1	0	1
ANG	0	1	0	1
AOA	0	1	0	1
ATS	1	1	1	1
AWG	1	1	1	1
AZM	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	1	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	1	0	1
UYU	0	1	0	1
VEB	0	1	0	1
VND	0	1	0	1
XOF	0	1	0	1
ZAR	0	1	0	1
ZWD	0	1	0	1