Export (0) Print
Expand All
Expand Minimize

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.

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.

Community Additions

ADD
Show:
© 2014 Microsoft