Northwind › Views
Current Product List view
69 rows. A view stores a SELECT statement, not rows: each time you open it, SQLite runs the query again.
Columns
| # | Name | Type | Not null | Default | Key | References |
|---|---|---|---|---|---|---|
| 0 | ProductID |
INTEGER |
no | — | ||
| 1 | ProductName |
TEXT |
no | — |
Definition
CREATE VIEW "Current Product List" AS
SELECT ProductID, ProductName
FROM Products
WHERE Discontinued = 0