Production.vProductAndDescription View

Description

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

Properties

Creation Date	08/01/2010 08:41
Is Schema Bound
Encrypted
Ansi Nulls

Columns

Column Name	Datatype	Length
ProductID	int	4
Name	dbo.Name	50
ProductModel	dbo.Name	50
CultureID	nchar	6
Description	nvarchar	400

Objects that Production.vProductAndDescription depends on

Database Object	Object Type	Description	Dep Level
Production.Culture	Table	Lookup table containing the languages in which some AdventureWorks data is stored.	2
dbo.Flag	User Defined Data Type		2
dbo.Name	User Defined Data Type		2
Production.Product	Table	Products sold or used in the manfacturing of sold products.	1
Production.ProductCategory	Table	High-level product categorization.	3
Production.ProductDescription	Table	Product descriptions in several languages.	1
Production.ProductModel	Table	Product model classification.	1
Production.ProductModelProductDescriptionCulture	Table	Cross-reference table mapping product descriptions and the language the description is written in.	1
Production.ProductSubcategory	Table	Product subcategories. See ProductCategory table.	2
Production.UnitMeasure	Table	Unit of measure lookup table.	2

View Definition

CREATE VIEW [Production].[vProductAndDescription] 
WITH SCHEMABINDING 
AS 

SELECT 
p.[ProductID] 
,p.[Name] 
,pm.[Name] AS [ProductModel] 
,pmx.[CultureID] 
,pd.[Description] 
FROM [Production].[Product] p 
INNER JOIN [Production].[ProductModel] pm 
ON p.[ProductModelID] = pm.[ProductModelID] 
INNER JOIN [Production].[ProductModelProductDescriptionCulture] pmx 
ON pm.[ProductModelID] = pmx.[ProductModelID] 
INNER JOIN [Production].[ProductDescription] pd 
ON pmx.[ProductDescriptionID] = pd.[ProductDescriptionID];

Related Objects