Properties

Owner:	Production
Creation Date:	04/26/2006
Located On:	PRIMARY
Data Size KB:	8
Index Size KB:	24
Rows:	8
Description:	Lookup table containing the languages in which some AdventureWorks data is stored.

Columns

		Name	Data Type	Length	NULL	Default	IsIdentity	IsGUID	Description
		CultureID	nchar	6					Primary key for Culture records.
		Name	Name	100					Culture description.
		ModifiedDate	datetime	8		(getdate())			Date and time the record was last updated.

Total: 3 column(s)

Indexes

	Index	Primary	Unique	Description
	PK_Culture_CultureID			Primary key (clustered) constraint
	AK_Culture_Name			Unique nonclustered index.

Total: 2 index(es)

Referencing Tables

	Table	Foreign Key	Primary Key or Unique Constraint
	Production.ProductModelProductDescriptionCulture	FK_ProductModelProductDescriptionCulture_Culture_CultureID	PK_Culture_CultureID

Total: 1 table(s)

Objects that [Production].[Culture] depends on

	Object Name	Owner	Object Type	Dep Level
	Name	dbo	User Defined type	1

Total: 1 object(s)

Objects that depend on [Production].[Culture]

	Object Name	Owner	Object Type	Dep Level
	ProductModelProductDescriptionCulture	Production	Table	1
	vProductAndDescription	Production	View	2

Total: 2 object(s)

SQL

CREATE TABLE [Culture] (
    [CultureID] [nchar] (6) COLLATE Latin1_General_CS_AS NOT NULL ,
    [Name] [Name] NOT NULL ,
    [ModifiedDate] [datetime] NOT NULL CONSTRAINT [DF_Culture_ModifiedDate] DEFAULT (getdate()),
    CONSTRAINT [PK_Culture_CultureID] PRIMARY KEY  CLUSTERED
    (
        [CultureID]
    )  ON [PRIMARY]
) ON [PRIMARY]
GO

See Also

List of tables