Generated using SQL Data Dictionary demo version.


View Sales.vStoreWithContacts


Stores (including store contacts) that sell Adventure Works Cycles products to consumers.


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: