AdventureWorks
| View Name: | Production.vProductModelCatalogDescription |
| Description: | Displays the content from each element in the xml column CatalogDescription for each product in the Production.ProductModel table that has catalog data. |
| Field | Type | Nulls? |
|---|---|---|
| ProductModelID | int | No |
| Name | nvarchar (50) | No |
| Summary | nvarchar (MAX) | Yes |
| Manufacturer | nvarchar (MAX) | Yes |
| Copyright | nvarchar (30) | Yes |
| ProductURL | nvarchar (256) | Yes |
| WarrantyPeriod | nvarchar (256) | Yes |
| WarrantyDescription | nvarchar (256) | Yes |
| NoOfYears | nvarchar (256) | Yes |
| MaintenanceDescription | nvarchar (256) | Yes |
| Wheel | nvarchar (256) | Yes |
| Saddle | nvarchar (256) | Yes |
| Pedal | nvarchar (256) | Yes |
| BikeFrame | nvarchar (MAX) | Yes |
| Crankset | nvarchar (256) | Yes |
| PictureAngle | nvarchar (256) | Yes |
| PictureSize | nvarchar (256) | Yes |
| ProductPhotoID | nvarchar (256) | Yes |
| Material | nvarchar (256) | Yes |
| Color | nvarchar (256) | Yes |
| ProductLine | nvarchar (256) | Yes |
| Style | nvarchar (256) | Yes |
| RiderExperience | nvarchar (1024) | Yes |
| rowguid | uniqueidentifier | No |
| ModifiedDate | datetime | No |