Production.vProductAndDescription (view)

wikibot

View	Production.vProductAndDescription
Description	Product 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 Type	Object Type	Referenced Object
Select	Table	Production.Product
Select	Table	Production.ProductDescription
Select	Table	Production.ProductModel
Select	Table	Production.ProductModelProductDescriptionCulture
Schema	Schema	Production

automatically generated

view	Production.vProductAndDescription
Description	Product names and descriptions. Product descriptions are provided in multiple languages.

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

Dependency Type	Object Type	Referenced Object
Select	Table	Production.Product
Select	Table	Production.ProductDescription
Select	Table	Production.ProductModel
Select	Table	Production.ProductModelProductDescriptionCulture
Schema	Schema	Production