Prepare the Northwind Database

Prepare the Northwind database into a consistant H2 db to provide a database environment to play with

These tables are included in the local database
knime://knime.workflow/../data/Northwind_small.h2

(they all have a unique ID "<tablename>id")

shipper
product
customerdemographic
employee
customercustomerdemo
supplier
orders
category
region
employeeterritory
customer
orderdetail
territory

one VIEW with a combination of informations
productdetails_v

External resources

• SQL H2 - more examples
• northwind-SQLite3/Northwind_small.sqlite