View: vProductModelCatalogDescription

Properties

Property	Value
Name	vProductModelCatalogDescription
ID	1947153982
Schema	Production
Owner	dbo
Encrypted
Schema Bound
With Check Option
ANSI NULLS
Uses Quoted Identifier
Has Opaque Metadata
Published
Schema Published
Replicated
Has Replication Filter
Has Unchecked Assembly Data
Date Correlation View
Uses Database Collation
Tracked by CDC
MS Shipped
Modify Date	8/8/2010 5:23:46 PM
Create Date	8/8/2010 5:23:46 PM

Extended Properties

View Columns

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

Indexes

Object Level Permissions

Column Level Permissions

Objects that depend on [vProductModelCatalogDescription]

• Production.vProductModelCatalogDescription

Objects on which [vProductModelCatalogDescription] depends

• Production.vProductModelCatalogDescription
  • CatalogDescription.value
  • Production.ProductModel
    • dbo.Name
    • Production.ManuInstructionsSchemaCollection
    • Production.ProductDescriptionSchemaCollection

SQL

See also