Generated using SQL Data Dictionary demo version.
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 |