Northwind › Views
Alphabetical list of products 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 | — | ||
| 2 | SupplierID |
INTEGER |
no | — | ||
| 3 | CategoryID |
INTEGER |
no | — | ||
| 4 | QuantityPerUnit |
TEXT |
no | — | ||
| 5 | UnitPrice |
REAL |
no | — | ||
| 6 | UnitsInStock |
INTEGER |
no | — | ||
| 7 | UnitsOnOrder |
INTEGER |
no | — | ||
| 8 | ReorderLevel |
INTEGER |
no | — | ||
| 9 | Discontinued |
INTEGER |
no | — | ||
| 10 | CategoryName |
TEXT |
no | — |
Definition
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