← All tables and views
Northwind view
Alphabetical list of products
Native view in the Northwind sample database.
69rows
11 columns
Schema from the provider contract| Column | Type | Nullable | Key | References |
|---|---|---|---|---|
ProductID | TEXT | yes | — | — |
ProductName | TEXT | yes | — | — |
SupplierID | TEXT | yes | — | — |
CategoryID | TEXT | yes | — | — |
QuantityPerUnit | TEXT | yes | — | — |
UnitPrice | TEXT | yes | — | — |
UnitsInStock | TEXT | yes | — | — |
UnitsOnOrder | TEXT | yes | — | — |
ReorderLevel | TEXT | yes | — | — |
Discontinued | TEXT | yes | — | — |
CategoryName | TEXT | yes | — | — |
View 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))Data preview
Sample records
| ProductID | ProductName | SupplierID | CategoryID | QuantityPerUnit | UnitPrice | UnitsInStock |
|---|---|---|---|---|---|---|
| 1 | Chai | 1 | 1 | 10 boxes x 20 bags | 18 | 39 |
| 2 | Chang | 1 | 1 | 24 - 12 oz bottles | 19 | 17 |
| 3 | Aniseed Syrup | 1 | 2 | 12 - 550 ml bottles | 10 | 13 |
| 4 | Chef Anton's Cajun Seasoning | 2 | 2 | 48 - 6 oz jars | 22 | 53 |
| 6 | Grandma's Boysenberry Spread | 3 | 2 | 12 - 8 oz jars | 25 | 120 |
| 7 | Uncle Bob's Organic Dried Pears | 3 | 7 | 12 - 1 lb pkgs. | 30 | 15 |
| 8 | Northwoods Cranberry Sauce | 3 | 2 | 12 - 12 oz jars | 40 | 6 |
| 10 | Ikura | 4 | 8 | 12 - 200 ml jars | 31 | 31 |