Databases > Northwind > Tables > Customers

Northwind

Customers

Created: Modified:

Columns

  • CustomerID
    [nchar](5) NOT NULL
  • CompanyName
    [nvarchar](40) NOT NULL
  • ContactName
    [nvarchar](30) NULL
  • ContactTitle
    [nvarchar](30) NULL
  • Address
    [nvarchar](60) NULL
  • City
    [nvarchar](15) NULL
  • Region
    [nvarchar](15) NULL
  • PostalCode
    [nvarchar](10) NULL
  • Country
    [nvarchar](15) NULL
  • Phone
    [nvarchar](24) NULL
  • Fax
    [nvarchar](24) NULL

Indexes

  • PK_Customers
    UNIQUE CLUSTERED
    CustomerID
  • City
    NONCLUSTERED
    City
  • CompanyName
    NONCLUSTERED
    CompanyName
  • PostalCode
    NONCLUSTERED
    PostalCode
  • Region
    NONCLUSTERED
    Region

Sample Data

CustomerID
CompanyName
ContactName
ContactTitle
Address
City
Region
PostalCode
Country
Phone
Fax
ALFKI
Alfreds Futterkiste
Maria Anders
Sales Representative
Obere Str. 57
Berlin
NULL
12209
Germany
030-0074321
030-0076545
ANATR
Ana Trujillo Emparedados y helados
Ana Trujillo
Owner
Avda. de la Constitución 2222
México D.F.
NULL
05021
Mexico
(5) 555-4729
(5) 555-3745
ANTON
Antonio Moreno Taquería
Antonio Moreno
Owner
Mataderos 2312
México D.F.
NULL
05023
Mexico
(5) 555-3932
NULL
AROUT
Around the Horn
Thomas Hardy
Sales Representative
120 Hanover Sq.
London
NULL
WA1 1DP
UK
(171) 555-7788
(171) 555-6750
BERGS
Berglunds snabbköp
Christina Berglund
Order Administrator
Berguvsvägen 8
Luleå
NULL
S-958 22
Sweden
0921-12 34 65
0921-12 34 67
BLAUS
Blauer See Delikatessen
Hanna Moos
Sales Representative
Forsterstr. 57
Mannheim
NULL
68306
Germany
0621-08460
0621-08924
BLONP
Blondesddsl père et fils
Frédérique Citeaux
Marketing Manager
24, place Kléber
Strasbourg
NULL
67000
France
88.60.15.31
88.60.15.32
BOLID
Bólido Comidas preparadas
Martín Sommer
Owner
C/ Araquil, 67
Madrid
NULL
28023
Spain
(91) 555 22 82
(91) 555 91 99
BONAP
Bon app'
Laurence Lebihan
Owner
12, rue des Bouchers
Marseille
NULL
13008
France
91.24.45.40
91.24.45.41
BOTTM
Bottom-Dollar Markets
Elizabeth Lincoln
Accounting Manager
23 Tsawassen Blvd.
Tsawassen
BC
T2F 8M4
Canada
(604) 555-4729
(604) 555-3745
BSBEV
B's Beverages
Victoria Ashworth
Sales Representative
Fauntleroy Circus
London
NULL
EC2 5NT
UK
(171) 555-1212
NULL
CACTU
Cactus Comidas para llevar
Patricio Simpson
Sales Agent
Cerrito 333
Buenos Aires
NULL
1010
Argentina
(1) 135-5555
(1) 135-4892
CENTC
Centro comercial Moctezuma
Francisco Chang
Marketing Manager
Sierras de Granada 9993
México D.F.
NULL
05022
Mexico
(5) 555-3392
(5) 555-7293
CHOPS
Chop-suey Chinese
Yang Wang
Owner
Hauptstr. 29
Bern
NULL
3012
Switzerland
0452-076545
NULL
COMMI
Comércio Mineiro
Pedro Afonso
Sales Associate
Av. dos Lusíadas, 23
Sao Paulo
SP
05432-043
Brazil
(11) 555-7647
NULL
CONSH
Consolidated Holdings
Elizabeth Brown
Sales Representative
Berkeley Gardens 12 Brewery
London
NULL
WX1 6LT
UK
(171) 555-2282
(171) 555-9199
DRACD
Drachenblut Delikatessen
Sven Ottlieb
Order Administrator
Walserweg 21
Aachen
NULL
52066
Germany
0241-039123
0241-059428
DUMON
Du monde entier
Janine Labrune
Owner
67, rue des Cinquante Otages
Nantes
NULL
44000
France
40.67.88.88
40.67.89.89
EASTC
Eastern Connection
Ann Devon
Sales Agent
35 King George
London
NULL
WX3 6FW
UK
(171) 555-0297
(171) 555-3373
ERNSH
Ernst Handel
Roland Mendel
Sales Manager
Kirchgasse 6
Graz
NULL
8010
Austria
7675-3425
7675-3426
FAMIA
Familia Arquibaldo
Aria Cruz
Marketing Assistant
Rua Orós, 92
Sao Paulo
SP
05442-030
Brazil
(11) 555-9857
NULL
FISSA
FISSA Fabrica Inter. Salchichas S.A.
Diego Roel
Accounting Manager
C/ Moralzarzal, 86
Madrid
NULL
28034
Spain
(91) 555 94 44
(91) 555 55 93
FOLIG
Folies gourmandes
Martine Rancé
Assistant Sales Agent
184, chaussée de Tournai
Lille
NULL
59000
France
20.16.10.16
20.16.10.17
FOLKO
Folk och fä HB
Maria Larsson
Owner
Åkergatan 24
Bräcke
NULL
S-844 67
Sweden
0695-34 67 21
NULL
FRANK
Frankenversand
Peter Franken
Marketing Manager
Berliner Platz 43
München
NULL
80805
Germany
089-0877310
089-0877451