Northwind
Basic Index Expanded Index
| View Name: | Current Product List |
| Field | Type | Nulls? | | ProductID | int | No |
| ProductName | nvarchar (40) | No |
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