Generated using SQL Data Dictionary demo version.

View Sales.vPersonDemographics

Displays the content from each element in the xml column Demographics for each customer in the Person.Person table.

Column Data Type Nullable
BusinessEntityID int
TotalPurchaseYTD money X
DateFirstPurchase datetime X
BirthDate datetime X
MaritalStatus nvarchar(1) X
YearlyIncome nvarchar(30) X
Gender nvarchar(1) X
TotalChildren int X
NumberChildrenAtHome int X
Education nvarchar(30) X
Occupation nvarchar(30) X
HomeOwnerFlag bit X
NumberCarsOwned int X