Generated using SQL Data Dictionary demo version.


View HumanResources.vEmployee


Employee names and addresses.


Column Data Type Nullable
BusinessEntityID int
Title nvarchar(8) X
FirstName Name(nvarchar(50))
MiddleName Name(nvarchar(50)) X
LastName Name(nvarchar(50))
Suffix nvarchar(10) X
JobTitle nvarchar(50)
PhoneNumber Phone(nvarchar(25)) X
PhoneNumberType Name(nvarchar(50)) X
EmailAddress nvarchar(50) X
EmailPromotion int
AddressLine1 nvarchar(60)
AddressLine2 nvarchar(60) X
City nvarchar(30)
StateProvinceName Name(nvarchar(50))
PostalCode nvarchar(15)
CountryRegionName Name(nvarchar(50))
AdditionalContactInfo xml X

Uses: