Alphabetical list of products
Fields
| Field name | Ordinal | Native type | Length | Precision | Scale | Is Nullable | Is Identity |
|---|---|---|---|---|---|---|---|
| ProductID | 1 | int | 0 | 10 | 0 | ||
| ProductName | 2 | nvarchar | 40 | 0 | 0 | ||
| SupplierID | 3 | int | 0 | 10 | 0 | Yes | |
| CategoryID | 4 | int | 0 | 10 | 0 | Yes | |
| QuantityPerUnit | 5 | nvarchar | 20 | 0 | 0 | Yes | |
| UnitPrice | 6 | money | 0 | 19 | 4 | Yes | |
| UnitsInStock | 7 | smallint | 0 | 5 | 0 | Yes | |
| UnitsOnOrder | 8 | smallint | 0 | 5 | 0 | Yes | |
| ReorderLevel | 9 | smallint | 0 | 5 | 0 | Yes | |
| Discontinued | 10 | bit | 0 | 0 | 0 | ||
| CategoryName | 11 | nvarchar | 15 | 0 | 0 |
Model elements mapped on this view
None.