Object type: Data view

Product names and descriptions. Product descriptions are provided in multiple languages.

Properties 

Transactional	Uses cursors	Executes procedures	Dynamic content	Encrypted
No	No	No	No	No

Data Source Activity 

Accesses	Description
Production.Product	Products sold or used in the manfacturing of sold products.
Production.ProductDescription	Product descriptions in several languages.
Production.ProductModel	Product model classification.
Production.ProductModelProductDescriptionCulture	Cross-reference table mapping product descriptions and the language the description is written in.

Output Recordset 

Column	Description
ProductID
Name
ProductModel
CultureID
Description

Data source	Description
Production.Product	Products sold or used in the manfacturing of sold products.
Production.ProductDescription	Product descriptions in several languages.
Production.ProductModel	Product model classification.
Production.ProductModelProductDescriptionCulture	Cross-reference table mapping product descriptions and the language the description is written in.

Indices 

Name	Description
IX_vProductAndDescription	Clustered index on the view vProductAndDescription.

Applies to

Views

The AdventureWorks database sample was developed by Microsoft Corporation, copyright 2005. SQL Server is a trademark of Microsoft Corporation