Description
Employees' names, titles, and personal information.
View properties
| name | value |
|---|
| name | ~sq_fEmployees |
| created | 8/16/2008 9:43:30 PM |
| modified | 8/16/2008 9:43:30 PM
|
Columns
| column | datatype | length | nulls | comment |
|---|
| EmployeeID | long | 4 | yes
| Number automatically assigned to new employee.
|
| LastName | text | 20 | no
| |
| FirstName | text | 10 | no
| |
| Title | text | 30 | yes
| Employee's title.
|
| TitleOfCourtesy | text | 25 | yes
| Title used in salutations.
|
| BirthDate | datetime | 8 | yes
| |
| HireDate | datetime | 8 | 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
| |
| HomePhone | text | 24 | yes
| Phone number includes country code or area code.
|
| Extension | text | 4 | yes
| Internal telephone extension number.
|
| Photo | OLE object | 0 | yes
| Picture of employee.
|
| Notes | memo | 0 | yes
| General information about employee's background.
|
| ReportsTo | long | 4 | yes
| Employee's supervisor.
|
Dependency graph
Objects that ~sq_fEmployees depends on
Sample rows
| EmployeeID | LastName | FirstName | Title | TitleOfCourtesy | BirthDate | HireDate | Address | City | Region | PostalCode | Country | HomePhone | Extension | Photo | Notes | ReportsTo |
|---|
| 1
| Davolio
| Nancy
| Sales Representative
| Ms.
| 12/8/1948 12:00:00 AM
| 5/1/1992 12:00:00 AM
| 507 - 20th Ave. E.
Apt. 2A
| Seattle
| WA
| 98122
| USA
| (206) 555-9857
| 5467
| System.Byte[]
| Education includes a BA in psychology from Colorado State University in 1970. She also completed "T...
| 2
|
| 2
| Fuller
| Andrew
| Vice President, Sales
| Dr.
| 2/19/1952 12:00:00 AM
| 8/14/1992 12:00:00 AM
| 908 W. Capital Way
| Tacoma
| WA
| 98401
| USA
| (206) 555-9482
| 3457
| System.Byte[]
| Andrew received his BTS commercial in 1974 and a Ph.D. in international marketing from the Universit...
| NULL
|
| 3
| Leverling
| Janet
| Sales Representative
| Ms.
| 8/30/1963 12:00:00 AM
| 4/1/1992 12:00:00 AM
| 722 Moss Bay Blvd.
| Kirkland
| WA
| 98033
| USA
| (206) 555-3412
| 3355
| System.Byte[]
| Janet has a BS degree in chemistry from Boston College (1984). She has also completed a certificate...
| 2
|
| 4
| Peacock
| Margaret
| Sales Representative
| Mrs.
| 9/19/1937 12:00:00 AM
| 5/3/1993 12:00:00 AM
| 4110 Old Redmond Rd.
| Redmond
| WA
| 98052
| USA
| (206) 555-8122
| 5176
| System.Byte[]
| Margaret holds a BA in English literature from Concordia College (1958) and an MA from the American ...
| 2
|
| 5
| Buchanan
| Steven
| Sales Manager
| Mr.
| 3/4/1955 12:00:00 AM
| 10/17/1993 12:00:00 AM
| 14 Garrett Hill
| London
| NULL
| SW1 8JR
| UK
| (71) 555-4848
| 3453
| System.Byte[]
| Steven Buchanan graduated from St. Andrews University, Scotland, with a BSC degree in 1976. Upon jo...
| 2
|
| 6
| Suyama
| Michael
| Sales Representative
| Mr.
| 7/2/1963 12:00:00 AM
| 10/17/1993 12:00:00 AM
| Coventry House
Miner Rd.
| London
| NULL
| EC2 7JR
| UK
| (71) 555-7773
| 428
| System.Byte[]
| Michael is a graduate of Sussex University (MA, economics, 1983) and the University of California at...
| 5
|
| 7
| King
| Robert
| Sales Representative
| Mr.
| 5/29/1960 12:00:00 AM
| 1/2/1994 12:00:00 AM
| Edgeham Hollow
Winchester Way
| London
| NULL
| RG1 9SP
| UK
| (71) 555-5598
| 465
| System.Byte[]
| Robert King served in the Peace Corps and traveled extensively before completing his degree in Engli...
| 5
|
| 8
| Callahan
| Laura
| Inside Sales Coordinator
| Ms.
| 1/9/1958 12:00:00 AM
| 3/5/1994 12:00:00 AM
| 4726 - 11th Ave. N.E.
| Seattle
| WA
| 98105
| USA
| (206) 555-1189
| 2344
| System.Byte[]
| Laura received a BA in psychology from the University of Washington. She has also completed a cours...
| 2
|
| 9
| Dodsworth
| Anne
| Sales Representative
| Ms.
| 1/27/1966 12:00:00 AM
| 11/15/1994 12:00:00 AM
| 7 Houndstooth Rd.
| London
| NULL
| WG2 7LT
| UK
| (71) 555-4444
| 452
| System.Byte[]
| Anne has a BA degree in English from St. Lawrence College. She is fluent in French and German.
| 5
|
Code
SELECT DISTINCTROW
*
FROM Employees;