← All tables and views
Northwind view
Current Product List
Native view in the Northwind sample database.
69rows
2 columns
Schema from the provider contract| Column | Type | Nullable | Key | References |
|---|---|---|---|---|
ProductID | TEXT | yes | — | — |
ProductName | TEXT | yes | — | — |
View definition
CREATE VIEW [Current Product List]
AS
SELECT ProductID,
ProductName
FROM Products
WHERE Discontinued=0Data preview
Sample records
| ProductID | ProductName |
|---|---|
| 1 | Chai |
| 2 | Chang |
| 3 | Aniseed Syrup |
| 4 | Chef Anton's Cajun Seasoning |
| 6 | Grandma's Boysenberry Spread |
| 7 | Uncle Bob's Organic Dried Pears |
| 8 | Northwoods Cranberry Sauce |
| 10 | Ikura |