AdventureWorks Database > Production Schema : Production.vProductModelCatalogDescription View |
Creation Date | 08/01/2010 08:41 |
Is Schema Bound | ![]() |
Encrypted | ![]() |
Ansi Nulls | ![]() |
Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
---|---|---|---|---|---|---|---|
ProductModelID | int | 4 | |||||
Name | dbo.Name | 50 | |||||
Summary | nvarchar | 16 | ![]() | ||||
Manufacturer | nvarchar | 16 | ![]() | ||||
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 | 16 | ![]() | ||||
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 | 16 | |||||
ModifiedDate | datetime | 4 |
Database Object | Object Type | Description | Dep Level | |
---|---|---|---|---|
![]() | dbo.Name | User Defined Data Type | 2 | |
![]() | Production.ProductModel | Table | Product model classification. | 1 |
|