ProductModel Table (AdventureWorks)
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. |