Employees

Transact-SQL Reference

Transact-SQL Reference

Employees

Column_name Data type Nullable Default Check Key/index
EmployeeID int no IDENTITY (1,1) PK clust.
LastName nvarchar(20) no Nonclust.
FirstName nvarchar(10) no
Title nvarchar(30) yes
TitleOfCourtesy nvarchar(25) yes
BirthDate datetime yes yes1
HireDate datetime yes
Address nvarchar(60) yes   
City nvarchar(15) yes
Region nvarchar(15) yes
PostalCode nvarchar(10) yes Nonclust.
Country nvarchar(15) yes
HomePhone nvarchar(24) yes
Extension nvarchar(4) yes
Photo image yes
Notes ntext yes
ReportsTo int yes FK Employees(EmployeeID)
Photopath nvarchar(255) yes

1  The BirthDate CHECK constraint is defined as (BirthDate < GETDATE()).

Note  Some entries in the Address column of the Employees table contain newline characters that may affect the format of the result set columns.