Read-only Back to SQLite3 Guide
Northwind › Tables
Customers table

Companies that buy from Northwind. A five-letter text key (ALFKI) instead of a number. 91 rows.

Data Structure
Columns
PRAGMA table_info
#NameTypeNot nullDefaultKeyReferences
0 CustomerID TEXT yes — PK
1 CompanyName TEXT yes —
2 ContactName TEXT no —
3 ContactTitle TEXT no —
4 Address TEXT no —
5 City TEXT no —
6 Region TEXT no —
7 PostalCode TEXT no —
8 Country TEXT no —
9 Phone TEXT no —
10 Fax TEXT no —
Indexes
PRAGMA index_list
NameColumnsUniqueCreated by
Customers_Region Region no CREATE INDEX
Customers_PostalCode PostalCode no CREATE INDEX
Customers_CompanyName CompanyName no CREATE INDEX
Customers_City City no CREATE INDEX
sqlite_autoindex_Customers_1 CustomerID yes PRIMARY KEY
Referenced by

Orders.CustomerID → Customers.CustomerID
CustomerCustomerDemo.CustomerID → Customers.CustomerID

Definition
from sqlite_schema
CREATE TABLE Customers ( CustomerID TEXT NOT NULL PRIMARY KEY, CompanyName TEXT NOT NULL, ContactName TEXT, ContactTitle TEXT, Address TEXT, City TEXT, Region TEXT, PostalCode TEXT, Country TEXT, Phone TEXT, Fax TEXT )