Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Contains the product model classifications and also provides a product catalog and manufacturing instructions, which are both stored as xml data types.
ProductModel Table Definition
The ProductModel table is contained in the Production schema.
| Column | Data type | Nullability | Description |
|---|---|---|---|
ProductModelID |
int |
Not null |
Primary key for ProductModel rows. |
Name |
Name (user-defined type) nvarchar(50) |
Not null |
Product model description. |
CatalogDescription |
xml |
Null |
Detailed product catalog information in XML format. For more information, see About the ProductModel.CatalogDescription xml Column. |
Instructions |
xml |
Null |
Manufacturing instructions in XML format. For more information, see About the ProductModel.Instructions xml Column. |
rowguid |
uniqueidentifier ROWGUIDCOL |
Not null |
ROWGUIDCOL number uniquely identifying the row. Used to support a merge replication sample. |
ModifiedDate |
datetime |
Not null |
Date and time the row was last updated. |
See Also
Reference
Illustration Table (AdventureWorks)
Product Table (AdventureWorks)
ProductCategory Table (AdventureWorks)
ProductModelIllustration Table (AdventureWorks)
ProductSubcategory Table (AdventureWorks)
Other Resources
AdventureWorks Data Dictionary