text: ﻿CREATE VIEW [SalesLT].[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.[Culture]
      ,pd.[Description]
  FROM [SalesLT].[Product] p
      INNER JOIN [SalesLT].[ProductModel] pm
      ON p.[ProductModelID] = pm.[ProductModelID]
      INNER JOIN [SalesLT].[ProductModelProductDescription] pmx
      ON pm.[ProductModelID] = pmx.[ProductModelID]
      INNER JOIN [SalesLT].[ProductDescription] pd
      ON pmx.[ProductDescriptionID] = pd.[ProductDescriptionID];
  
  GO
  CREATE UNIQUE CLUSTERED INDEX [IX_vProductAndDescription]
      ON [SalesLT].[vProductAndDescription]([Culture] ASC, [ProductID] ASC);
  
  