Description
Suppliers' names, addresses, phone numbers, and hyperlinks to home pages.
View properties
| name | value |
|---|
| name | ~sq_fSuppliers |
| created | 8/16/2008 9:43:30 PM |
| modified | 8/16/2008 9:43:30 PM
|
Columns
| column | datatype | length | nulls | comment |
|---|
| SupplierID | long | 4 | yes
| Number automatically assigned to new supplier.
|
| 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.
|
| HomePage | memo | 0 | yes
| Supplier's home page on World Wide Web.
|
Dependency graph
Objects that ~sq_fSuppliers depends on
Sample rows
| SupplierID | CompanyName | ContactName | ContactTitle | Address | City | Region | PostalCode | Country | Phone | Fax | HomePage |
|---|
| 1
| Exotic Liquids
| Charlotte Cooper
| Purchasing Manager
| 49 Gilbert St.
| London
| NULL
| EC1 4SD
| UK
| (171) 555-2222
| NULL
| NULL
|
| 2
| New Orleans Cajun Delights
| Shelley Burke
| Order Administrator
| P.O. Box 78934
| New Orleans
| LA
| 70117
| USA
| (100) 555-4822
| NULL
| #CAJUN.HTM#
|
| 3
| Grandma Kelly's Homestead
| Regina Murphy
| Sales Representative
| 707 Oxford Rd.
| Ann Arbor
| MI
| 48104
| USA
| (313) 555-5735
| (313) 555-3349
| NULL
|
| 4
| Tokyo Traders
| Yoshi Nagase
| Marketing Manager
| 9-8 Sekimai
Musashino-shi
| Tokyo
| NULL
| 100
| Japan
| (03) 3555-5011
| NULL
| NULL
|
| 5
| Cooperativa de Quesos 'Las Cabras'
| Antonio del Valle Saavedra
| Export Administrator
| Calle del Rosal 4
| Oviedo
| Asturias
| 33007
| Spain
| (98) 598 76 54
| NULL
| NULL
|
| 6
| Mayumi's
| Mayumi Ohno
| Marketing Representative
| 92 Setsuko
Chuo-ku
| Osaka
| NULL
| 545
| Japan
| (06) 431-7877
| NULL
| Mayumi's (on the World Wide Web)#http://www.microsoft.com/accessdev/sampleapps/mayumi.htm#
|
| 7
| Pavlova, Ltd.
| Ian Devling
| Marketing Manager
| 74 Rose St.
Moonie Ponds
| Melbourne
| Victoria
| 3058
| Australia
| (03) 444-2343
| (03) 444-6588
| NULL
|
| 8
| Specialty Biscuits, Ltd.
| Peter Wilson
| Sales Representative
| 29 King's Way
| Manchester
| NULL
| M14 GSD
| UK
| (161) 555-4448
| NULL
| NULL
|
| 9
| PB Knäckebröd AB
| Lars Peterson
| Sales Agent
| Kaloadagatan 13
| Göteborg
| NULL
| S-345 67
| Sweden
| 031-987 65 43
| 031-987 65 91
| NULL
|
| 10
| Refrescos Americanas LTDA
| Carlos Diaz
| Marketing Manager
| Av. das Americanas 12.890
| São Paulo
| NULL
| 5442
| Brazil
| (11) 555 4640
| NULL
| NULL
|
Code
SELECT DISTINCTROW
*
FROM Suppliers;