Sales.Currency

Table: 'Sales.Currency'

3 fields. 122 bytes.

Lookup table containing standard ISO currencies.

Field NameData TypeSizeOriginal TypeDefaultNullableDescriptionCheck
CurrencyCodenchar3  Not nullThe ISO code for the Currency. 
NameName nvarchar(50) Not nullCurrency name. 
ModifiedDatedatetime  getdate()Not nullDate and time the record was last updated. 

Extended Properties

The object has no extended properties.

Primary key for table 'Sales.Currency'

Primary Key NameField Name
PK_Currency_CurrencyCodeCurrencyCode
There are no Foreign Keys for this table.

Indexes for table 'Sales.Currency', 2 items

Index NameDescriptionClusteredUniqueFields
PK_Currency_CurrencyCodeClustered index created by a primary key constraint.YesYesCurrencyCode
AK_Currency_NameUnique nonclustered index.NoYesName

Triggers for table 'Sales.Currency', 1 item

NameDescriptionTypeEnabled
uCurrencyAFTER UPDATE trigger setting the ModifiedDate column in the Currency table to the current date.after Update Yes

Dependencies for table 'Sales.Currency', 1 item

Object NameTypeField Name
Sales.uCurrencytriggerN/A