Owner: Sales 
Creation Date: 04/26/2006 
Located On: PRIMARY 
Data Size KB:
Index Size KB: 24 
Rows: 105 
Description: Lookup table containing standard ISO currencies. 


Name Data Type Length NULL Default IsIdentity IsGUID Description
    CurrencyCode  nchar          The ISO code for the Currency. 
    Name  Name  100          Currency name. 
    ModifiedDate  datetime    (getdate())      Date and time the record was last updated. 
Total: 3 column(s)


Index Primary Unique Description
  PK_Currency_CurrencyCode      Primary key (clustered) constraint 
  AK_Currency_Name      Unique nonclustered index. 
Total: 2 index(es)

Referencing Tables

Table Foreign Key Primary Key or Unique Constraint
  Sales.CountryRegionCurrency  FK_CountryRegionCurrency_Currency_CurrencyCode  PK_Currency_CurrencyCode 
  Sales.CurrencyRate  FK_CurrencyRate_Currency_FromCurrencyCode  PK_Currency_CurrencyCode 
  Sales.CurrencyRate  FK_CurrencyRate_Currency_ToCurrencyCode  PK_Currency_CurrencyCode 
Total: 3 table(s)

Objects that [Sales].[Currency] depends on

Object Name Owner Object Type Dep Level
  Name  dbo  User Defined type 
Total: 1 object(s)

Objects that depend on [Sales].[Currency]

Object Name Owner Object Type Dep Level
  CountryRegionCurrency  Sales  Table 
  CurrencyRate  Sales  Table 
  SalesOrderHeader  Sales  Table 
  vSalesPersonSalesByFiscalYears  Sales  View 
  SalesOrderDetail  Sales  Table 
  SalesOrderHeaderSalesReason  Sales  Table 
  uSalesOrderHeader  Sales  Trigger 
  iduSalesOrderDetail  Sales  Trigger 
Total: 8 object(s)


CREATE TABLE [Currency] (
    [CurrencyCode] [nchar] (3) COLLATE Latin1_General_CS_AS NOT NULL ,
    [Name] [Name] NOT NULL ,
    [ModifiedDate] [datetime] NOT NULL CONSTRAINT [DF_Currency_ModifiedDate] DEFAULT (getdate()),
    )  ON [PRIMARY]

See Also

List of tables