Generated using SQL Data Dictionary demo version.


View Purchasing.vVendorWithContacts


Vendor (company) names and the names of vendor employees to contact.


Column Data Type Nullable
BusinessEntityID int
Name Name(nvarchar(50))
ContactType Name(nvarchar(50))
Title nvarchar(8) X
FirstName Name(nvarchar(50))
MiddleName Name(nvarchar(50)) X
LastName Name(nvarchar(50))
Suffix nvarchar(10) X
PhoneNumber Phone(nvarchar(25)) X
PhoneNumberType Name(nvarchar(50)) X
EmailAddress nvarchar(50) X
EmailPromotion int

Uses: