Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

wikibot

ViewProduction.vProductAndDescription
DescriptionProduct names and descriptions. Product descriptions are provided in multiple languages.

Source

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];

References

Dependency TypeObject TypeReferenced Object
SelectTableProduction.Product
SelectTableProduction.ProductDescription
SelectTableProduction.ProductModel
SelectTableProduction.ProductModelProductDescriptionCulture
SchemaSchemaProduction

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam.