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       
Total: 2 column(s)

Objects that [dbo].[Current Product List] depends on

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

SQL

create view "Current Product List" AS
SELECT Product_List.ProductID, Product_List.ProductName
FROM Products AS Product_List
WHERE (((Product_List.Discontinued)=0))
--ORDER BY Product_List.ProductName

See Also

List of views