Description
Customers' names, addresses, and phone numbers.
View properties
| name | value |
|---|
| name | ~sq_fCustomer Phone List |
| created | 8/16/2008 9:43:30 PM |
| modified | 8/16/2008 9:43:30 PM
|
Columns
| column | datatype | length | nulls | comment |
|---|
| CustomerID | text | 5 | yes
| Unique five-character code based on customer name.
|
| CompanyName | text | 40 | no
| |
| ContactName | text | 30 | yes
| |
| ContactTitle | text | 30 | yes
| |
| Address | text | 60 | yes
| Street or post-office box.
|
| City | text | 15 | yes
| |
| Region | text | 15 | yes
| State or province.
|
| PostalCode | text | 10 | yes
| |
| Country | text | 15 | yes
| |
| Phone | text | 24 | yes
| Phone number includes country code or area code.
|
| Fax | text | 24 | yes
| Phone number includes country code or area code.
|
Dependency graph
Objects that ~sq_fCustomer Phone List depends on
Sample rows
| 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
| Blondel 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
|
Code
SELECT DISTINCTROW
*
FROM Customers;