Production.vProductAndDescription View

Description

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

Properties

Creation Date	27/10/2017 14:33
Is Schema Bound
Encrypted
Ansi Nulls

Columns

Column Name	Datatype	Length
ProductID	Integer	4
Name	dbo.Name	50
ProductModel	dbo.Name	50
CultureID	WChar	6
Description	VarWChar	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 

-- View (indexed or standard) to display products and product descriptions by language.
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