Generated using SQL Data Dictionary demo version.


View Production.vProductModelCatalogDescription


Displays the content from each element in the xml column CatalogDescription for each product in the Production.ProductModel table that has catalog data.


Column Data Type Nullable
ProductModelID int
Name Name(nvarchar(50))
Summary nvarchar(max) X
Manufacturer nvarchar(max) X
Copyright nvarchar(30) X
ProductURL nvarchar(256) X
WarrantyPeriod nvarchar(256) X
WarrantyDescription nvarchar(256) X
NoOfYears nvarchar(256) X
MaintenanceDescription nvarchar(256) X
Wheel nvarchar(256) X
Saddle nvarchar(256) X
Pedal nvarchar(256) X
BikeFrame nvarchar(max) X
Crankset nvarchar(256) X
PictureAngle nvarchar(256) X
PictureSize nvarchar(256) X
ProductPhotoID nvarchar(256) X
Material nvarchar(256) X
Color nvarchar(256) X
ProductLine nvarchar(256) X
Style nvarchar(256) X
RiderExperience nvarchar(1024) X
rowguid uniqueidentifier
ModifiedDate datetime

Uses: