Tables SQL 2005 Adventure Works OLTP

Production.Culture

Object type: Table

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
The AdventureWorks database sample was developed by Microsoft Corporation, copyright 2005. SQL Server is a trademark of Microsoft Corporation

Document was prepared on: Thursday, April 05, 2007
Help compiled by DBDocumentor, a Pikauba Software product. All rights reserved.