Tables | SQL 2005 Adventure Works OLTP |
Lookup table containing the languages in which some AdventureWorks data is stored.
Columns
Name Data type Nullable Description CultureID nchar(6) No Primary key for Culture records. Name Name No Culture description. ModifiedDate datetime No Default value: GETDATE()
Date and time the record was last updated.
Constraints
Name Type Columns Description DF_Culture_ModifiedDate DEFAULT ModifiedDate Value: GETDATE()
Default constraint value of GETDATE()PK_Culture_CultureID PRIMARY KEY CultureID Clustered index created by a primary key constraint.
Indices
Name Description AK_Culture_Name Unique nonclustered index.
Triggers
Name Description Production.uCulture AFTER UPDATE trigger setting the ModifiedDate column in the Culture table to the current date.
Linked tables
Name Description Production.ProductModelProductDescriptionCulture Cross-reference table mapping product descriptions and the language the description is written in.
Modified by
Name Description Production.uCulture AFTER UPDATE trigger setting the ModifiedDate column in the Culture table to the current date.
Applies to
Tables | User