Northwind Explorer

Region table

Four regions: Eastern, Western, Northern, Southern. 4 rows.

Columns

PRAGMA table_info

#	Name	Type	Not null	Default	Key	References
0	`RegionID`	`INTEGER`	no	—	PK
1	`RegionDescription`	`TEXT`	yes	—

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

Territories.RegionID → Region.RegionID

Definition

from sqlite_schema

CREATE TABLE Region (
    RegionID          INTEGER PRIMARY KEY,
    RegionDescription TEXT NOT NULL
)