Properties

Owner: dbo 
Schema bound:  
Encrypted:  
Creation Date: 08/06/2000 
Description:  

Columns

Name Data Type Length NULL IsGUID Description
  ProductID  int       
  ProductName  nvarchar  80       
  SupplierID  int       
  CategoryID  int       
  QuantityPerUnit  nvarchar  40       
  UnitPrice  money       
  UnitsInStock  smallint       
  UnitsOnOrder  smallint       
  ReorderLevel  smallint       
  Discontinued  bit       
  CategoryName  nvarchar  30       
Total: 11 column(s)

Objects that [dbo].[Alphabetical list of products] depends on

Object Name Owner Object Type Dep Level
  Categories  dbo  Table 
  Suppliers  dbo  Table 
  Products  dbo  Table 
Total: 3 objects

SQL

create view "Alphabetical list of products" AS
SELECT Products.*, Categories.CategoryName
FROM Categories INNER JOIN Products ON Categories.CategoryID = Products.CategoryID
WHERE (((Products.Discontinued)=0))

See Also

List of views