Northwind Explorer

Shippers table

Three freight companies. Orders.ShipVia points here. 3 rows.

Columns

PRAGMA table_info

#	Name	Type	Not null	Default	Key
0	`ShipperID`	`INTEGER`	no	—	PK
1	`CompanyName`	`TEXT`	yes	—
2	`Phone`	`TEXT`	no	—

Indexes

PRAGMA index_list

No separate indexes. The INTEGER PRIMARY KEY is the rowid itself, so the table's own B-tree already serves lookups by key.

Referenced by

Orders.ShipVia → Shippers.ShipperID

Definition

from sqlite_schema

CREATE TABLE Shippers (
    ShipperID   INTEGER PRIMARY KEY,
    CompanyName TEXT NOT NULL,
    Phone       TEXT
)