Table: 'Production.Culture'

3 fields. 128 bytes.

Lookup table containing the languages in which some AdventureWorks data is stored.

Field NameData TypeSizeOriginal TypeDefaultNullableDescriptionCheck
CultureIDnchar6  Not nullPrimary key for Culture records. 
NameName nvarchar(50) Not nullCulture description. 
ModifiedDatedatetime  getdate()Not nullDate and time the record was last updated. 

Extended Properties

The object has no extended properties.

Primary key for table 'Production.Culture'

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

Indexes for table 'Production.Culture', 2 items

Index NameDescriptionClusteredUniqueFields
PK_Culture_CultureIDClustered index created by a primary key constraint.YesYesCultureID
AK_Culture_NameUnique nonclustered index.NoYesName

Triggers for table 'Production.Culture', 1 item

uCultureAFTER UPDATE trigger setting the ModifiedDate column in the Culture table to the current date.after Update Yes

Dependencies for table 'Production.Culture', 1 item

Object NameTypeField Name